Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    8

    Unanswered: @@SourceRow: Logging Failed

    I defined exception file in the DTS package options. I didn't use SQL7.0 format file.

    A file with the following contents was created. But a source error file was not. Can someone have the similar experience?

    DATA TRANSFORMATION SERVICES: Data Pump Exception Log



    @@ErrorRow: 496702
    Error during Transformation 'DTSTransformation__94' for Row number 496702. Errors encountered so far in this task: 8.

    Error Source: Microsoft Data Transformation Services (DTS) Data Pump
    Error Description:ActiveX Scripting Transform 'DTSTransformation__94' encountered an invalid data value for 'ANNUITY_BEGIN_DT' destination column.
    Error Help File:sqldts80.hlp
    Error Help Context ID:30632
    @@SourceRow: Logging Failed

    Error code: 80004005


    @@ExecutionCompleted

    Execution Completed: 3/24/2004 1:57:32 PM

    ************************************************** **************************************************

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Enable DTS package logging for further information.

    Also try to delete the transform between those to columns and map them to the right columns...
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •