Post reply

Losing first row using DTS to import CSV file

  • May 12, 2005 at 7:59 am

    #102523

    I'm losing the first record on the CSV file when using an DTS to import a CSV file.  Any ideas?

  • May 12, 2005 at 10:19 am

    #558472

    Look at the properties of the connection for the file.  Is the "first row has column names" option checked?  That will make the import skip the first row.

    Greg

    Greg

  • May 12, 2005 at 10:29 am

    #558478

    I have changed my DTS to import it as an text file with comma dilimiters and it seems to be working.

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

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