locked
Importing .CSV file to Sql Server RRS feed

  • Question

  • how to  Import .CSV file to Sql Server 2008 R2 using SSIS

    • Edited by sinner1988 Wednesday, May 30, 2012 10:02 PM
    Wednesday, May 30, 2012 10:00 PM

Answers

  • Use File System Task in control flow to copy this CSV file to a txt file, then you can handle this txt file in data flow task by flat file source.

    Refer to my test figures

    Source connection to CSV file.

    Destination connection to create a txt file.

    You need to execute this task firstly to generate this txt file.

    Then create a data flow task to connect to this txt file and load data.


    Hope it helps! Vote if it's helpful! Simon MSN:simonlv@live.cn Skype:simonlvpin

    • Proposed as answer by BIWORKMVP Thursday, May 31, 2012 4:43 AM
    • Marked as answer by sinner1988 Thursday, May 31, 2012 3:46 PM
    Thursday, May 31, 2012 3:17 AM

All replies