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
Ant-Green
SSC Guru
Points: 113445
More actions
January 22, 2013 at 4:48 am
#1579558
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.