locked
Importing CSV file RRS feed

  • Question

  • I'm a newbie to SSIS, so there is probably an easy solution:

     

    I'm importing from a csv file into a db table, but would like to remove the quotation marks from around the data before inserting into the table.

     

    Are there any suggestions of how to remove the "data" marks?  Would a Foreach Loop container work for this?

    Monday, June 4, 2007 4:16 PM

Answers

  • Set the text qualifier in the Flat FIle connection manager to "
    Monday, June 4, 2007 5:28 PM