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

  • Have you set the connection manager of the flat file source to use an expression on the connection string of the variable?

    That will ensure that the filename on the connection manager changes with each file it finds.