Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Replication (2005)  Replication DTS import Issue

Author  Topic  aXiniXe Starting Member 1 Post Posted - 2009-11-19 : 09:19:56 Hi there, I'm having an issue with my DTS import package. There reason why i post it in the replication forum is because the package only fails when replication is used. My DTS package is used to import data in the databases. It does this by first copying all data in the database (tables which are not being replicated, so no problem there). Then for each row in the table it runs a stored procedure. This stored procedure itself inserts or updates some tables and also runs some other stored procedures which have logic of their own. The problem is that during the processing of the rows. I recieve the following error message out of the blue: The INSERT statement conflicted with the FOREIGN KEY constraint and so on.. The procedures are indeed updating columns which have foreign keys, but in a normal database, which doens't have replication, everything runs smoothly. I've searched the web, found some stuff about fast load (which i disabled) and so on, but nothing particular about foreign keys problems. Maybe there is some identity treashold of various tables due to replication? which i checked. I'm only importing 600 rows... while the tables itself have atleast 100000 rows. Strange thing is, is does import some rows, somewhat less then 50 on every package run. So if i run it 20 times, all data would be imported... but that is not the idea Thx in advance for any help.