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 |
|
urpalshu
Starting Member
21 Posts |
 Posted - 2005-08-26 : 12:03:09
|
| Hello,I have about 25 .txt files, which I need to import into SQL Server 2000.Please could anyone tell me the fastest way to do this. Since all my data to be transfered is in the same format. I can save the DTS. But how do I use the saved DTS?Is it better to save it as SQL Server or Visual Basic.Please could anyone give me detailed steps as to how I can do it fast, with syntax or example.I am new to DTS.Thank you |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-08-26 : 17:30:30
|
Hi,Use bcp/ bulInsert tools to import the text data into tables. These 2 are faster as compare to DTS.Please look into SQL Sever 2000 Books online for bcp and BulkInsert.Have a nice day  With RegardsBSR |
 |
|
|
|
|
|
DTS