How do I deal with FK constraints when importing data using DTS Import/Export Wizard?
I was given this solution over at SQLTeam.com:


  Use:

 EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'

  
  Then import your data

EXEC sp_msforeachtable 'ALTER TABLE ? CHECK CONSTRAINT all'



Using that method I was able to import all the data in with no issues.