[dba-SQLServer] Bulk insert

I agree that BULK INSERT is faster. If quoted values in your source
file are causing problems when using BCP, one thing you might try is
to import first into MS Access which handles quoted values easily.
Then export the data from Access as tab delmited. You can then specify
the tab character as the field terminator in your BCP command with the
switch, -t"\t"

Good luck.

On 5/1/07, Eric Barro <ebarro at verizon.net> wrote:
> DTS may be more flexible but it is significantly slower than BULK INSERT.
>