| Raek Doe 2002-10-03, 1:24 am |
| Data can also be transferred into a SQL Server table from a data file using
the BULK INSERT statement. However, the BULK INSERT statement cannot bulk
copy data from an instance of SQL Server to a data file. The BULK INSERT
statement allows you to bulk copy data to an instance of SQL Server using
the functionality of the bcp utility with a Transact-SQL statement, rather
than from the command prompt.
HTH,
Kevin
It is also possible to write programs to bulk copy SQL Server data to or
from a data file using the bulk copy API. The bulk copy API can be used in
ODBC, OLE DB, SQL-DMO, and DB-Library-based applications."Stephen Wood"
<stephenwo@coserv.net> wrote in message
news:uoa6tc3hh8gef5@corp.supernews.com...
> Rob Vieira's book states that DTS can do "most anything" that the BCP
> program can do.
>
> What I'm wondering is:
>
> Is there anything that you can do with BCP that you can't do with DTS?
>
>
|