job failed, but data loaded in DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

job failed, but data loaded in DTS

Hi All
if anyone has this issue with DTS package. we use DTS package to import data using query from one server to another server. the data is loaded, but the job shows failure. the following is the message: Copy Data from Results to [db_name].[dbo].[table_name] Step DTSRun OnError: Copy Data from Results to [db_name].[dbo].[table_name] Step, Error = -2147467259 (80004005) Error string: Error at Destination for Row number 113. 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: The statement has been terminated. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147467259 (80004005); Provider Error: 2627 (A43) Error string: Violation of PRIMARY KEY constraint ‘PK_SCAN_STATISTICS’. Cannot insert duplicate key in object ‘SCAN_STATISTICS’. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnProgre… Process Exit Code 1. The step failed. the data is loaded to destination. there is not duplicate data in the primary key. anyone know why? thanks in advance,
surely, there is data duplicate error.
there won’t any duplicates in destination. What is your source. is it a table or a query. whatever, what is the column by refers to ‘PK_SCAN_STATISTICS’. check what is the data that you are try to insert in to taht column. there should be duplcaites there. OR ESLE remove ‘PK_SCAN_STATISTICS’ PK and re-start the job. then check whether there are are duplcaites. I 100% sure there are duplicates, —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
‘PK_SCAN_STATISTICS’–it’s primary key contraint in the destination table. we use query to filter the data. i check the data retrieved from the query. no duplicate data exist. the job fails some days. the other days it runs fine.
I had the same issue from a DTS. one days fails not in some days. my query returns duplicate data from the query. I modified query so that I won’t return any duplicate records —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
]]>