Home Forums SQL Server 2008 SQL Server 2008 - General Importing a csv file into a database - inserts quotes automatically into every field RE: Importing a csv file into a database - inserts quotes automatically into every field

  • I've had a look at the stairways section on SSIS, and re-built the package from scratch.

    I can now import some of the postcode data into my SQL table successfully without the " speech marks!

    However, the loop imports the same single file about 60 times and doesn't import any of the other files.

    It imports the file I specify in the Flat File Connection Manager (e.g. ab.csv).

    In my loop Collection properties I have specified my folder where there are about 120 csv files and in the Files box I have entered *.csv

    I have created a variable name with index of 0 (but not using this variable name anywhere else in any expression).