Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    229

    Unanswered: "Bulk copy insert failed"

    I'm copying data from tables in one server to tables in another via DTS.

    This package have worked fine before, but now (after having refreshed the database information, and re-selected the tables), I'm getting a SQL-DMO: The Bulk Copy execution failed, without no further details.

    When selecting a limited subset of the table, I got no errors.
    Might be just one of the tables maybe that's causing the error, but there are so many tables so it takes some time to pinpoint which one.

    Any hints?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Can you post the actual dts package or be more specific in how the package works ?

  3. #3
    Join Date
    Jul 2002
    Posts
    229
    I was just going to delete my posting. It was really simple - a column in a table was defined as varchar(50) in the source database but varchar(20) in the destination. I thought the data would "just" be truncated.
    After altering the destination column to 50, the package worked fine.

    But, the error message really gave no help at all, and the error message info stored in msdb was just blank.
    Is the only way to get a proper error message to do some coding in VBscript?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •