Cannot find column delimiter

• pop

  SSCrazy

  Points: 2130

  More actions

  October 5, 2007 at 8:49 am

  #118877

  Hi All,

  I have several instances where I Import a comma delimited file, which has the " as a text qualifier. This worked with no problem in DTS, but the same file in SSIS produces "Cannot find column delimiter for xyz column".

  Does anyone know how to handle this or run into this situation? I would think it's pretty common scenario. Thanks!

• pop

  SSCrazy

  Points: 2130

  More actions

  October 8, 2007 at 2:20 pm

  #740152

  I found the solution in case anyone else has the same issue. It's the last post listed here:

  http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=855663&SiteID=17