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 |
swatib
Posting Yak Master
173 Posts |
Posted - 2007-01-10 : 02:19:46
|
Hi All,How do I transfer data from text file to database using DTS?ThanksNjoy Life |
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-01-10 : 02:23:26
|
Why do you want to use dts.It can be done in tsql using the BULK INSERT command.Look it up in BOLDuane. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-10 : 02:35:16
|
or using BCP.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-10 : 03:28:18
|
Or OPENROWSET.Peter LarssonHelsingborg, Sweden |
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2007-01-10 : 03:47:56
|
Thanks Ditch............. I tried it........it works........Njoy Life |
|
|
|
|
|