Post reply

DTS TEXT IMPORT ERROR

  • January 23, 2002 at 5:57 pm

    #104868

    For some reason, the DTS script I created in SQL 2000 can not be configured to skip the first record. How can I insure that a <LF> or <CR> is present?

    When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

    Once you've accepted your flaws, no one can use them against you.

  • January 24, 2002 at 9:53 am

    #422610

    Not sure I understand. If there is not EOL marker, how can SQL fix this?

    You could use an ActiveX script to check the first character of the file for a EOL, but it wouldn't help ensure the first line was skipped. This is a source issue.

    I'd import the whole thing and then look at the first row to check if it needs to be deleted.

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply