sql server dts: import/export wont include identity/primary key -- sql server dts

import/export wont include identity/primary key

Reth
7/29/2004 11:02:59 PM

sql server dts:

Each time when i import the tables from 1 SQL server to an
other, it wont include the Identity's and Primary key's.

how can i make it so it will?

thx in advance,

Re: import/export wont include identity/primary key

Allan Mitchell
7/30/2004 7:47:59 AM

How are you doing this?

If you are using a DatPump task then it won't do this.

If you are using the Transfer Objects task then have a look at the options
button on the last tab of the setup. You caan specify what to take across
there.

--
--

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

[quoted text, click to view]