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 |
|
terrking@nmsu.edu
Starting Member
4 Posts |
 Posted - 2007-12-13 : 17:36:11
|
| my DTS package has run successfully for 2 years through a scheduled job - the package updates tables, creates 2 files and drops each file on a separate server - I was dropping the files using FTP processes but I had to change one of them to WinSCP - I can manually execute the package and it runs flawlessly - but when the job runs it it fails when it tries to run the WinSCP process - all other parts of the package run okay - Could I have overlooked something regarding permissions or the interaction of WinSCP with a job? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-13 : 17:45:26
|
| To troubleshoot job failures that run a DTS package, log into the database server using the same account that the SQL Server service uses. Go to the designer and execute the package there. You should see better errors from there than from the job. The key point is doing this directly on the database server using the same account as the SQL Server service. This simulates what a job does.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
terrking@nmsu.edu
Starting Member
4 Posts |
Posted - 2007-12-13 : 17:49:05
|
| the package executes without errors from designerTerry |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-13 : 17:57:16
|
| Yes but did you execute it in the exact way that I described?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
terrking@nmsu.edu
Starting Member
4 Posts |
Posted - 2007-12-13 : 18:20:11
|
| I log in to the server as the owner of both the package and job Terry |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-13 : 18:22:49
|
| That isn't what I said to do and is not a valid test when troubleshooting jobs with DTS packages.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
terrking@nmsu.edu
Starting Member
4 Posts |
Posted - 2007-12-13 : 18:35:39
|
| I'm quite new at this and I apologize if I don't understand you but doesn't sql service use the owner's account? or am I just totally out in left field?Terry |
|
|
|
|
|
|
Only Part of DTS Works for Job