by I am having a problem with a DTS package not running when done as a
scheduled job. This is a job that has run many times in the past just
fine. The only thing I changed was, I redid the transformations in the
DTS package, and instead of typing them in, I imported a .vbs file for
each of the transformations. The source data is Microsoft Access and
the destination is SQL Server. The DTS package ran OK when I did it
manually, but fails every time when I try to execute the job. Here is
the error message (there are 11 DataPumpTasks in this package):
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_2
DTSRun OnStart: DTSStep_DTSDataPumpTask_3
DTSRun OnStart: DTSStep_DTSDataPumpTask_4
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887
(80040E21)
Error string: Errors occurred
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0
Error Detail Records: Error: -2147217887 (80040E21); Provider
Error: 0 (0)
Error string: Errors occurred
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_5
DTSRun OnError: DTSStep_DTSDataPumpTask_5, Error = -2147217887
(80040E21)
Error string: Errors occurred
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0
Error Detail Records... Process Exit Code 11. The step failed.
Can anyone help me?
Sent via Deja.com
http://www.deja.com/