SQL Server Performance

Random import error on scheduled job

Discussion in 'SQL Server DTS-Related Questions' started by tariquer, Jul 21, 2004.

  1. tariquer New Member

    Hi
    I 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
  2. satya Moderator

    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.

Share This Page