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 |
|
k006b
Starting Member
10 Posts |
 Posted - 2005-01-27 : 16:41:20
|
| Dear all,I am a beginner to DTS, Daily i need to import around 25 CSV files from a directory eg. c:\myimport to a table on sqlserver. Can anyone guide me as to how to create a DTS which would import all the files inside myimport to the table.Thanks in advanceK006b |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2005-01-28 : 09:50:07
|
| I discovered this product a couple of days ago, Id use DTS to call a DOS batch file that runs this program against each of your files.http://www.logparser.com/If you do go this route, could you post back here and let me know how easy or otherwise it was to get runningCheersGraham |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-01-28 : 11:12:37
|
| You don't need DTS to do this task. I wouldn't use it for what you want to do. (I very much dislike using DTS for much of anything ...)Have a look at www.sqldts.com (check out Looping, Importing and Archivingto get some ideas).Jay White |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2005-01-29 : 06:57:57
|
| Have to agree with page here - have a look at Robs blog to get an idea. It uses command-line scripting and bcp to accomplish this task.http://weblogs.sqlteam.com/robv/archive/2003/09/28/181.aspx |
|
|
|
|
|
|
importing multiple csv files using DTS