Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbaman
Starting Member
46 Posts |
 Posted - 2009-08-27 : 08:51:00
|
| One of my developer developed a SSIS package. When you run the package standalone it runs fine.Now I am trying to run an SSIS package from the SQL Agent. When I try to run the package from the agent, I get the error "The package execution failed. The step failed." I only have one step in the job and it doesn't include any scripts. Are there any permissions I need to set for the agent? What am I missing?I even tried this:I. Create job executor accountHighlight Security->New Login, say to make login as devlogin, type your password, default database can be your target database.Server roles: check ?sysadmin?User mapping: your target databaseMsdb database: you make sure to include SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRoleThen click OK II. Create SQL proxy account and associate proxy account with job executor accountHere is the code and run it the query window. Use masterCREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomain\myWindowAccount', secret = 'WindowLoginPassword'Use msdbSp_add_proxy @proxy_name='MyProxy', @credential_name='MyCredential'Sp_grant_login_to_proxy @login_name=' devlogin', @proxy_name='MyProxy'Sp_grant_proxy_to_subsystem @proxy_name='MyProxy', @subsystem_name='SSIS'Still getting same error.What I am missing?R |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-27 : 09:08:48
|
| 1. Why does the new login require sysadmin? That's probably NOT required.2. What does the package log file say? Any errors there? Have you enabled logging in th package? |
 |
|
|
|
|
|
Run SSIS Package as Job (Using Agent)