Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    41

    Unanswered: Errors on importing a text file

    When a DTS fails on a Text Source input with an error like "DTS_Transformation encountered an invalid data value for 'Column1' destination"


    Is there a way to get the line number of the textfile where the import failed? It is hard to determine where in my 40,000-line file it found the invalid value for my column.

    Thanks,
    Andrew

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Specify the LOG file in Package Properties/Logging.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    May 2003
    Posts
    41
    WHere does it store the logs on the server?

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Wherever you would like it to be.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    May 2003
    Posts
    41
    I set the error log file to a text file on my esktop - it seems to repeat the same error message (without the line number) - am i missing something?

Posting Permissions

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