Hi,

I want to copy a few tables from SQL Server 2000 to Excel and back. The data
in these tables has foreign key relationships made through IDENTITY columns.

e.g.:
CREATE TABLE Reservation
(ID INT IDENTITY PRIMARY KEY
,SomeColumns ...)

CREATE TABLE ReservationItem
(ID INT IDENTITY PRIMARY KEY
,Reservation INT NOT NULL REFERENCES Reservation (ID)
,SomeColumns ...)

How can I simply perform transfer of the data while maintaining the foreign
key relationship? As far as I can see there is no way to perform a "SET
IDENTITY_INSERT Reservation ON" in a simple DTS data transform task.

TIA,
Axel Dahmen

Have a look here

Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Axel Dahmen" <NO_SPAM (AT) NoOneKnows (DOT) de> wrote