DTS import does not get all rows

• phani kumar gotety

  Ten Centuries

  Points: 1213

  More actions

  May 29, 2005 at 1:06 am

  #66550

  Hi,

  I am trying to import data from an SQL2000 database to a 7.0 database. Most of the tables' rows get transferred but for some tables some rows are not getting imported.

  I have tried multiple times but the same less number gets imported. Tried importing with deleting target rows also but no use

  Any ideas on this ??

  Regards

  Phani

• amackay_1

  Ten Centuries

  Points: 1240

  More actions

  May 30, 2005 at 10:04 am

  #561744

  A few questions that may help:

  Is DTS giving any error messages about rows not being transferred? 

  Are the table structures exactly the same between the 2 databases? (check unique indexes that require unique values for example) 

  Are there any triggers in the SQL 7.0 database that may be deleting records as they are imported?

  Hope this helps,

  Andrew

• Syed Asim Rizvi

  Ten Centuries

  Points: 1162

  More actions

  May 31, 2005 at 7:59 am

  #561881

  If it is not including same rows everytime, it might be bad data in source.

• vinod-233276

  SSC Rookie

  Points: 39

  More actions

  June 1, 2005 at 1:02 am

  #562086

  h!!,

      In this scenario you can select the tables in which data is not transfered & clear the checkbox for ENFORCE RELATIONSHIP FOR INSERTS AND UPDATES

  Regards,

  Vinod (DBA)

  HTC Global Services Chennai

  Mob:09840856202