DTS / Bulk Copy failed

• jweyl

  SSC Veteran

  Points: 285

  More actions

  September 26, 2003 at 11:21 am

  #106511

  I have set up a DTS package with the option to copy all database objects. The core aspects of the package work, but the data itself is not copied. The table structures, stored procedure and user defined functions are all copied. But the data is missing. On this particular server this has happened with both SQL Server and using Embarcadero's DBArtisian program.

  Could the bcp utility on this server be corrupt? Has anyone else ever have this happen before?

• philcart

  SSC-Forever

  Points: 47797

  More actions

  September 29, 2003 at 5:20 pm

  #476279

  Can you successfully execute a manual BCP or BULK-INSERT statement?

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface