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 |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2007-05-10 : 05:47:53
|
| Hi,I'm new to SSIS after spending a long time with DTS. I am having a difficult time getting a SSIS package to run as a scheduled job, even though the package works fine when run manually.I read up on these problems and have completed all the neccesary instructions here:[url]http://www.codeproject.com/useritems/Schedule__Run__SSIS__DTS.asp[/url]but the package still refuses to execute through SQL Agent. The only error message I get in the History Log is:"The package execution failed. The step failed."I am running the job as the new Proxy user that I set up but it will not execute when scheduled. Can anyone offer any advice please?Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-10 : 10:35:43
|
| Does the proxy user have enough permission? |
 |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-05-11 : 08:01:25
|
| Yes, it has SysAdmin |
|
|
|
praveenkjohn
Starting Member
9 Posts |
Posted - 2007-05-11 : 08:10:13
|
| please check the Step where it get jammed, Next thing u can check is with SSIS package itself sometime for certain values it wont work . More important is the Sysadmin login u specified check properly whether he has the right to do soRegardsPraveen John+91-9895074288"Frankly, my dear, I don’t give a damn" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-11 : 09:43:25
|
| Does the package access remote data source? Does sql agent service account or proxy account have permission on remote data source? |
|
|
|
|
|
|
Cannot get scheduled SSIS to run