how to import multiple CSV files in folder into SQL Server 2012
Posted on 2014-12-22
I have SQL Server 2012. I want to import about 350+ CSV files located in a local folder of SQL 2012 server. I only need a one-time import at this time. I am new to SQL Server 2012, but have researched my problem extensively with BCP, Bulk Insert, OPENROWSET, and SSIS. Please assist with the easiest way possible. Thank you.