Post reply

Problem in Bulk Insert task

  • June 16, 2010 at 4:42 am

    #1180854

    I'm afraid you can't merge the columns in the Bulk Insert Task.

    You could set-up a data flow with a Flat File Source where you read all of the file contents.

    Then use a derived column to merge to two columns to a new column.

    Finally, write everything away with the OLE DB Destination. Make sure you map only the columns that you need.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 16, 2010 at 4:45 am

    #1180856

    Thanks a lot. I'll try with that.

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

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