sql server dts: [quoted text, click to view]

"Copy SQL Server Objects" Task should work.
Otherwise you can first drop FK constraints, import data and then recreate
them.

--
Francesco Anti

Hello there

I have an empty database that i need to fill it with another database which
is similar. (backup of the current database)
In the database i have forign key constraints. So in order to enter data to
one table with foreign key i need to add the data first to the table with
the primary key and afterword to the table with the foreign key

The simple DTS does not ckeck it. Is there a way to make shure that the
primary key is being filled before the foreign key?

--
øåòé âåìãäîø
ù.î. òúéã äðãñú úåëðä
roy@atidsm.co.il
èì: 03-5611606
ôìà' 050-7709399