Below is the error message I am getting on my dts package - Any help will be
appreaciated.

Executed as user: BHCS\sqlsrv. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, 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: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete.
Process Exit Code 1. The step failed.

ODBC Connections use DSN's or Data Source Names. Check Control Panel, Data
Sources, and verify that the DSN exists. Make sure you do this on the
machine upon which the package is executing.

Looks like a job, so that is the SQL server itself.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Aboki" <Aboki (AT) discussions (DOT) microsoft.com> wrote