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 - 2003-10-16 : 08:21:11
|
| Frances writes "I created a package, which imports data from AS400 to SQL Server. There is no problem with executing the package manually in Enterprise Manager but with scheduling it. If I create a user DSN for the AS400 ODBC data source, the scheduled job always fails (the error message is: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified) . If I create a system DSN for the AS400 ODBC data source, the scheduled job starts and hangs there doing nothing (the job status is always "Executing"). On SQL Server, I used Windows authentication for everything where security is needed. I log on to the SQL Server using the network user account from my desktop PC. The account for SQL Server Agent is ADMIN (the most powerful Windows user on the server).Thanks in advance" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-10-16 : 10:28:29
|
| When you run a DTS package from Enterprise Manager, the execution takes place at the client machine you are sitting at. However, when you schedule a DTS package, it runs on the server.So, if the client and server machines are different, you need to make sure the server machine has the same DSNs configured.Damian |
 |
|
|
|
|
|
Schedule DTS job