SQL Server Performance

BCP Replacement

Discussion in 'Analysis Services/Data Warehousing' started by tusseyre, Feb 18, 2004.

  1. tusseyre New Member

    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.
  2. ChrisFretwell New Member

    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
  3. satya Moderator

    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.
  4. aldo2003 New Member

    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

Share This Page