SQL 2000 - Job failing

Question

Post reply

SQL 2000 - Job failing

Agnii

Ten Centuries

Points: 1192
More actions
December 29, 2010 at 10:02 pm

#72953

Hi team,
we are receiving the below error on one of jobs in our prod server which is running sql server 2000.
Here's the error from error log file.
DTSRun OnProgress: Copy Data from ef_mstr to [CHNImport].[dbo].[ef_mstr] Step; 69000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 69000
DTSRun OnProgress: Copy Data from ef_mstr to [CHNImport].[dbo].[ef_mstr] Step; 70000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 70000
DTSRun OnProgress: Copy Data from ef_mstr to [CHNImport].[dbo].[ef_mstr] Step; 71000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 71000
DTSRun OnProgress: Copy Data from ef_mstr to [CHNImport].[dbo].[ef_mstr] Step; 72000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 72000
DTSRun OnProgress: Copy Data from ef_mstr to [CHNImport].[dbo].[ef_mstr] Step; 73000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 73000
DTSRun OnError: Copy Data from ef_mstr to [CHNImport].[dbo].[ef_mstr] Step, Error = -2147467259 (80004005)
Error string: Error at Destination for Row number 73571. Errors encountered so far in this task: 1.
Error source: DTS Data Pump
Help file:
Help context: 0
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 3621 (E25)
Error string:
Error source:
Help file:
Help context: 0
Error: -2147467259 (80004005); Provider Error: 2627 (A43)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnProgress: Copy Data from ef_mstr to [CHNImport].[dbo].[ef_mstr] Step; 73571 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 73571
DTSRun OnError: Copy Data from ef_mstr to [CHNImport].[dbo].[ef_mstr] Step, Error = -2147220421 (8004043B)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error Detail Records:
Error: -2147220421 (8004043B); Provider Error: 0 (0)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

Error string: Error at Destination for Row number 73571.

You data pump succeeds up till the row indicated.

Inspect any form of transformation needed from source to destination and confirm if the row/record is eligible for this type of transformation.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

First thing I'd do is check the data at row #73571.

I am assuming you are importing data from a text file of some sort, so you should open it in a text editor and see if there is a problem at or around that record.