DTS and bigint

  • I try to copy a table and its data from one database to another.

    If I try to copy a table containing only one column (bigint) it works fine.

    If the table also contains a blob column it does not work, all columns defined with the datatype bigint gets changed.

    5020026265 becomes 725058969 and so on.

    However if I do not choose the option "Copy objects and data between SQLserver databases"

    and instead use the option "Copy tables and views from the source database"

    it works in all cases.

    Is this something fishy or have I missed something?

    /m

  • NEVER MIND

    it's an intermittent bug in DTS

    Found a way around it.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply