DTS TEXT IMPORT ERROR

• fizzleme

  SSCertifiable

  Points: 6906

  More actions

  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.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738012

  More actions

  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