I am having trouble with scheduled DTS packages. All of them can be manually run with success. However, only a few of them can be scheduled successfully. THe only one that is scheduled and DOES NOT WORK is the one that connects with the AS400. Again, i can run it with success manually but not when its scheduled. All of the packages run under the same account. Any suggestions?????

What error message do you get? Does the package have a connectivity issue or ???

Adam Gossage
Lake Wylie, SC, USA

"Executed as user: CMBECWEB\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from COLSQRV01B to [BirthCertificates_Test].[dbo].[tbl_ICOMS] Step DTSRun OnError: Copy Data from COLSQRV01B to [BirthCertificates_Test].[dbo].[tbl_ICOMS] Step, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from COLSQRV01B to [BirthCertificates_Test].[dbo].[tbl_ICOMS] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed."

When you say that they run them manually and they work, are you running them on your local machine or on the server via RDP/console? You will want to check that the server has the ODBC DSN and driver.

If that is not the issue, what is the environment? SQL Version, etc.

Adam Gossage
Lake Wylie, SC, USA