Post reply

DTS Import/Export Wizard- Integrity Violation

  • April 12, 2006 at 2:24 am

    #169038

    We have three databases which need moving from one server to another.  As a preliminary task I have copied the tables and data using DTS Import/Export Wizard for the programmers to test.  Two databases went over correctly but one has copied the tables but with no data.

    When I tried to copy the data across from one specific table, I got the error

    Insert error<column name> status 10:Integrity violation;attempt to insert NULL data or data which violates contraints

    Is this a programming error or have I not made the correct selections in DTS Import/Export Wizard?  These databases have been created a long time ago and various programmers have had their input into them.

     

    Madame Artois

  • April 12, 2006 at 6:25 am

    #632062

    It could be either, I guess. Take a look on the columnname in question if it allows nulls or not on your destination, and whether it also is as it's supposed to be..? It might not hurt to review the data you're moving as well. Perhaps you have something in there that's unexpected as well...

    /Kenneth

  • April 12, 2006 at 7:48 am

    #632094

    We have done some more work on this during the day and have discovered something odd.  When we originally did the DTS transfer, it failed when it couldn't find a particular user login.  This user had left some time ago.

    So we added the user login to the new location but only with the right of 'public' access to the database.  We then ran the DTS Import/Export again.  This time it worked completely and all the data, tables, stored procedures etc were copied to the new location.

    The programmers are trying to investigate why this happened (it didn't on the other two databases to which this long gone user had access).

    Have you got any thoughts on this?

     

     

    Madame Artois

  • April 12, 2006 at 7:56 am

    #632098

    No particular thoughts except that it seems to be permissions related in one way or another. I don't use DTS much, so I can't really say if this behaviour is common or not.

    /Kenneth

  • April 12, 2006 at 8:07 am

    #632103

    Thanks anyway.  It does seem strange though......

    Madame Artois

Viewing 5 posts - 1 through 4 (of 4 total)

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