question

kareem avatar image
kareem asked

We are trying to use SSIS Import export wizrd to import the flat files (CSV format) that we have into MS SQL Server 2014 database tables.

We are trying to use SSIS Import export wizrd to import the flat files (CSV format) that we have into MS SQL Server 2014 database tables. We have huge number of CSV files. Is there a way by which we can import these flat (CSV) files in to corresponding SQL server tables in a single shot. I would really appreciate this help as it is painful to convert each and every file using the Import Export wizard. Regards, Kareem
sql-server-2014csvimport-export-wizard
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
@SQLShark avatar image
@SQLShark answered
You need to upgrade from Import/Export to SSIS. You can do this with a foreach loop, loop over all files in folder and use an expression to point where they need to go. Link to an example [ http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx][1] [1]: http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.