DTS Error. Help!

• Will1922

  SSCertifiable

  Points: 7189

  More actions

  April 21, 2005 at 10:04 am

  #66196

  Here is the output file from my DTS transformation. I am pulling from an IEX server to a SQL 2000 server. There is plenty of space in the destination database. Why is this process stopping?

  DTSRun: Loading...

  DTSRun: Executing...

  DTSRun OnStart: DTSStep_DTSDataPumpTask_1

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 7000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 7000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 8000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 9000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 9000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 10000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 10000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 11000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 11000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 12000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 12000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 13000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 13000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 14000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 15000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 15000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 16000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 16000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 17000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 17000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 18000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 18000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 19000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 19000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 20000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 20000

  DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 21000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 21000

  DTSRun OnError: DTSStep_DTSDataPumpTask_1, 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_1

  DTSRun: Package execution complete.

  Thanks in advance for any responses to this post.

  WS5926

  ---

  Live to Throw
  Throw to Live
  Will Summers

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  April 21, 2005 at 10:17 am

  #554134

  This link may help you:

   

  http://dbforums.com/t502581.html

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!