Very Computer

by **mkerri..** » Fri, 09 Feb 2001 06:41:24

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/

by **Euan Garde** » Mon, 12 Feb 2001 17:08:18

Did you update the versionid that the schedule is calling?

-Euan

> 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/

by **Chris** » Tue, 13 Feb 2001 10:29:22

This is going to sound weird but I just solved this problem on a SQL
server.
I have been running a DTS Package remotely without problems, but as
soon as I try and execute the package as a scheduled job it fails.
Working directy on the server with PCAnywhere I opened the package and
opened and closed all the connections. Then saved and closed the
package. Now the package runs as a job sucessfully on the server.
I know it sounds unlikely but it fixed the problem.
--
Chris
Wellington, NZ

Sent via Deja.com
http://www.deja.com/

Very Computer

DTS/Job problem

DTS/Job problem

DTS/Job problem

DTS/Job problem