none
Column delimiter not found error in csv data import using DTS package.

    Question

  • I am trying to import a csv file data to sql server and the system is producing the "Column delimter not found" error in the dts package in the 31,000 line.
    I was not able to find a solution,I have searched so many sites.Please help.

    Tuesday, July 14, 2009 1:12 PM

Answers

  • What is the column delemiter you have set?
    Try using <CR> & <LF> separately.
    Hope this helps !! - Sudeep | Please mark the post(s) as “Answered” that answers your query.
    Tuesday, July 14, 2009 1:27 PM

All replies

  • What is the column delemiter you have set?
    Try using <CR> & <LF> separately.
    Hope this helps !! - Sudeep | Please mark the post(s) as “Answered” that answers your query.
    Tuesday, July 14, 2009 1:27 PM
  • Hi
    yes try using <CR> & <LF> separately and add an extra empty column in the ADD column section

    sh

    Monday, July 20, 2009 8:02 PM