DTS - Error

Hi,

I encouter a mystic behaviour:

1. When I am starting my DTS-package (using "other ODBC-Device" for connecting) by hand, it runs always reliable.

2. When I schedule this task, it gets always the following error:

Executed as user: ACB\Dienst-SQL. ...nStart: Copy Data from FZG_BST_DTN_247 to [Afib].[dbo].[FZG_BST_DTN_247] Step DTSRun OnError: Copy Data from FZG_BST_DTN_247 to [Afib].[dbo].[FZG_BST_DTN_247] 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 FZG_BST_DTN_247 to [Afib].[dbo].[FZG_BST_DTN_247] Step DTSRun OnStart: DTSStep_OMWCustomTasks.OMWTransferErrors_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSSt... Process Exit Code 12. The step failed.
:(

Can anybody explain me the different handling of a scheduled task and a task startet manually ?

Thx in advanceI would guess your dts package is using a user dsn to make one of your connections. When you schedule the job you are not running as the same user when you execute the package interactively and therefore you can not file the dsn.

If this is the case I think changing the dsn to a system dsn will fix the problem.

If you are not doing this then you'll need to give more information about how that specific connect is defined.