We have quite a few packages we setup with Enterprise manager and we are
running them from the command line using a batch file. They have been
running fine for 6 months and now one of the packages is getting the
following error.

DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 139000 Rows have been transfo
or copied.; PercentComplete = 0; ProgressCount = 139000
DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147221499 (80040005)
Error string: Need to run the object to perform this operation

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147221499 (80040005); Provider Error: 0 (0)
Error string: Need to run the object to perform this operation

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100


Error: -2147221499 (80040005); Provider Error: 0 (0)
Error string: Need to run the object to perform this operation

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4700


Error: -2147221499 (80040005); Provider Error: 0 (0)
Error string: Code execution exception: EXCEPTION_ACCESS_VIOLATION
Error source: Microsoft Data Transformation Services (DTS) Data Pump
Help file: sqldts80.hlp
Help context: 0

DTSRun OnFinish: DTSStep_DTSDataPumpTask_2
DTSRun: Package execution complete.

As far as I know nothing in the source database has changed which would bear
out the 139000 rows that process before it dies. Any help would be
appreciated.

Dave B

Hello Dave,

There are a number of reasons why you might get this error and I googled
to find you this list.

http://www.google.com/search?sourcei...s+operation%22

allan

Thank You, It turned out to be a data error that was apparantly blowing up
DTS with the ODBC connection we are using.

Dave


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote