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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 transfer data from text file to database

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?


Thanks

Njoy 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 BOL


Duane.
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-10 : 02:35:16
or using BCP.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-10 : 03:28:18
Or OPENROWSET.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

swatib
Posting Yak Master

173 Posts

Posted - 2007-01-10 : 03:47:56
Thanks Ditch............. I tried it........it works........



Njoy Life
Go to Top of Page
   

- Advertisement -