Post reply

Vertical bars not recognised in source csv

  • March 18, 2014 at 10:36 am

    #286825

    Hi all,

    We are migrating a package from DTS to SSIS 2008, however it is not recognising the vertical bars in a CSV file as column delimiters, whereas DTS has no problem acknowledging the bars in the the exact same file. Thus the output is shown as a single column, whereas there should be 9 or so.

    Any ideas what's happening guys?

    Cheers,

    Jake

  • March 18, 2014 at 10:53 am

    #1698126

    somewhere in your package, you've got a flat file connection manager.

    if you go to it's details, and go to the columns column, you can change the column delimiter from a comma to a pipe character, and you should be all set after that.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 18, 2014 at 11:00 am

    #1698130

    That's what I've been trying, but no dice. I've selected the bar from the drop down, reset/refreshed the columns several times, but it still presents as a heap.

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

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