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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-09-04 : 06:36:40
|
| Hi Experts,please tell me the difference between BCP and DTSprovide me links if possible.thankyou very much |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 06:51:42
|
| BCP can import and export flat text files very easy and fast.DTS can do that too, for almost all kind of files there is. In addition, DTS can be schemabound, run regurlaly without intervention. BCP can that too, but only with the help from a job that starts a SP.Books Online is a very useful resource.Peter LarssonHelsingborg, Sweden |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-09-04 : 07:08:20
|
| Thank you Mr peter.i got some idea. |
|
|
|
|
|
|
difference between BCP and DTS