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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-08 : 08:06:53
|
| vivian writes "I have a DTS package on serverA. This package was designed to import data from serverA to serverB, serverC, and serverA (to different table), and do the calculation on 3 different machine. After the calculation, all the calculated data will be pulled and imported to serverA again. If I execute this DTS package through DTS package window, everthng is cool, i wn't have any problems. If I run this package through a scheduled job, only part of package, which is on server A is executed, the job on server B and C never get executed. Could you please help me out?Thanks in advance!!!" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-08 : 08:58:51
|
| Check out microsofts article Q269074http://support.microsoft.com/default.aspx?scid=KB;EN-US;q269074&I had a similar problem and what I did to correct it was make sure the sql agent account has access to all necessary resources and modify the dtsrun command line in the scheduled job to have standard parameters versus the encrypted ones that sqlserver creates for you.Another option would be to schedule those jobs to run through a windows account that you know has access to all machines and use vbs (DTS Package Object) and windows scheduler to achieve your objective.Edited by - ValterBorges on 11/08/2002 09:02:33 |
 |
|
|
|
|
|
schedule a job