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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-01 : 09:20:39
|
| Arunachalam writes "What is the difference between the Data Transfer Service (DTS) and Bulk Copy Procedure (BCP) ?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-01 : 09:35:24
|
| bcp is a very lightweight command-line utility. It's pretty fast. DTS Bulk Insert is just as fast or faster. bcp can use a format file to process data.DTS is far more flexible, allowing you to perform incredibly detailed transformations on data (at the cost of speed). DTS can also import and export to just about any database product, not just text files (bcp only does text and native format data files, no Oracle, Excel, or any of that). DTS also puts several different steps into a package, and can be programmed in just about any programming language. You would have to create a DOS batch file to have similar functionality in bcp, and certain functions can't be done this way.Books Online has plenty of information about DTS and bcp. |
 |
|
|
|
|
|
Question about the difference between DTS and BCP