• One way to speed up the preprocessing of your CSV files is to use Log Parser to convert them to TSV files. A TSV should be easier for SSIS to make use of; Log Parser 2.2

    For example, if input.csv contained this:

    Author, Title,Quote

    "Salinger","The Catcher in the Rye","""People always think something's all true."""

    "Trumbo","Johnny Got His Gun", """S.O.S. Help me."""

    This would change the delimiters to tabs and remove the double quotes.

    LOGPARSER -i:CSV -o:TSV "SELECT Author, Title,Quote INTO output.tsv FROM input.csv"