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


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