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 |
|
dekayNY
Starting Member
1 Post |
 Posted - 2007-08-29 : 04:11:35
|
| Hi GuysCan anybody help with how to bulk insert multiple csv file into a table in a database at once. The csv file have different names so i don't know how to specify from which path should the data be retrieved and transmited to my table. the csv file have the same data format. Please help!!!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 01:33:20
|
| No, only one file at a time. |
 |
|
|
smithanataraj
Starting Member
2 Posts |
Posted - 2007-08-30 : 03:01:06
|
| You can create a DTS package for this. As far as the mapping files in different locations is concerned, you can use a mapped network drive in the file paths in the DTS. The corresponding folder with all these files can be mapped onto the respective drive, when the Package needs to be run.Hope this helps.. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-30 : 04:53:11
|
| you can run each import in a separate connection if you're doing it from .Net or SSMS_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Bulk inserting multiple files at once