Post reply

import text file to table using SSIS

  • February 20, 2008 at 11:37 am

    #71577

    Hi,

    I have a task to import a text file to table. The DTS has the way to create the table when designing the package. But I couldn't find the same function in SSIS. Do I have to create the table first and then design the SSIS package?

    Thanks

    ice

  • February 20, 2008 at 7:11 pm

    #780471

    Ice, after adding your DataFlowDestination (your SQL database) and have connected the output of the DataFlowSoure (text file) to the input of the DataFlowDestination, right click the destination and chose edit. After selecting the OleDBConnectionManger you can specify a NEW table and column mappings.

    Hope this helps,

    Doug

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

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