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 |
|
niall29
Starting Member
5 Posts |
 Posted - 2006-02-19 : 23:43:18
|
I made 9 DTSs which 8 of them run perfectly as scheduled jobs, but I have one that starts using FTP to get files from a Dialer and every time I set it up as a job it fails at step 1. I have looked at other forums at google searches and they all say it is a permissions issue. but I have checked and made the account a Sys Admin on the SQL server, I have gave the account read and write access to the share and, in the FTP step I put in the logon details that I want it to use. So I think I have everything covered but still it will not run as a scheduled job yet runs perfectly if I execute the DTS manually. |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2006-02-20 : 02:28:39
|
I had similar problem earlier with one of DTS package. Manually execute the package, it will run. If I put on schedule it will fail. Even after giving the SA permision I was not able to schedule the package. So finally, I created a batch file which calls this DTS Package and put it on Windows Task Scheduler, it worked. But I was never able to run that package as SQL Job, it always use to fail. I cant still figure out why it is so..  ThanksKarunakaran |
 |
|
|
|
|
|
DTS Running as Job