DTS step error

[LloydDobler]

Hi all. I have a DTS package set up to run every 8 hours, but the job fails when scheduled. if I execute the package it works fine, but here's the error I get after the scheduled job tries to run.

DTSRun OnError: Copy Data from Results to tbl_machinenumbers 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 Resul... Process Exit Code 1. The step failed.


Be quiet Brain, or I'll stab you with a Q-tip! (Homer Simpson)

 

[JohnDTampaBay]

When you execute a package, the package uses your resources (permissions, ODBC info, drive mappings, etc.) When you schedule a package, the package runs on the server using the resources available to (I think) SQL Server Agent.

These errors seems to point to ODBC. I would check out the ODBC settings on the server. Make sure that the DSN being called actually exists on the server. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)