SQL Server Performance Forum – Threads Archive

BCP Replacement

Looking for a Microsoft SQL Server tool/utility to replace the BCP utility. BCP is prone to ODBC error failure when BCPing data from the host database server across the network to a text file on another server. We have tried the DTS utility also. BCP is more reliable than the DTS utility. The replacement tool/utility needs to have characteristics like restartable mode, and retry capabilities. The tool/utitility could then continue if it encounter a ODBC error during the Microsoft SQL Server data export process instead of failing.

what kind of problems have you had with DTS? So far, I’ve been quite happy with it (more so with 2000 than 7) chris

I never had trouble with BCP and infact its a non-logged operation to save the TLog space.
You should check from network side for these errors what you say about ODBC error failire. What is the exact error you’re getting? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

If you don’t wish to use either BCP or DTS you could think about Bulk Insert as an option if you are loading from flat files. This is not available in SQL Server 6.x. V.fast way to bulk load data. Cheers

]]>