SQL Server Performance Forum – Threads Archive
Random import error on scheduled job
HiI am importing nightly 2 tables from MAS 90 to my sql server (user: sa). The strange thing is I get this error once in a while. Following is the error messege:
DTSRun OnStart: Copy Data from SO2_SOEntryDetailLine to [dbReport].[dbo].[SO2_SOEntryDetailLine] Step DTSRun OnError: Copy Data from SO2_SOEntryDetailLine to [dbReport].[dbo].[SO2_SOEntryDetailLine] Step, Error = -2146959361 (8007FFFF) Error string: Catastrophic failure Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2146959361 (8007FFFF); Provider Error: 0 (0) Error string: Catastrophic failure Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 DTSRun OnFinish: Copy Data from SO2_SOEntryDetailLine to [dbReport].[dbo].[SO2_SOEntryDetailLine] Step
again, this happens once in a while. When I rerun the packege in the morning or any other time. Another strange thing is that its not always the same table. It also sometimes fails on the 1st table SO1_SOEntryHeader. Any help will be appricieated
Check the source and destination values are specified correctly in the datapump.
Ensure similar levels of MDAC version and latest Service packs are installed when executing the package. I’d this issue once and found to be change in MDAC version between Client and server, after replacing the MDAC in similar to server resolved the issue. Also check thru event viewer, SQL server error log during this behaviour and try to enable DTS package logging for events. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>