Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Informer30
Starting Member
26 Posts |
 Posted - 2014-07-28 : 17:25:36
|
| Hi All,I want to know the best way to insert approx 500 csv files. Each file containing approx 70k rows.Each csv comes with suffix of datetimePlease can you advise...Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-28 : 17:45:57
|
| I would use SSIS, looping through the files.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-07-30 : 01:47:32
|
| Another option is powershell , which has very good handling on reading csv files,fine manipulation in general and connecting to SQL Server. It's usage will depend on how you manage you're overall SQL Server estate. Is the structure the same on all csv files?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2014-07-31 : 08:29:23
|
| Another option is to use BCP utility and Batch file to loop through CSV files in the folder. |
|
|
|
|
|
|
Best way to Bulk Insert