How can I copy IDENTITY property of source
column to destination column in DTS?
"ENable identity insert" property does not affect
the transfer

TIA, Sandra

Have a look at this article

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

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Margarita" <anonymous (AT) discussions (DOT) microsoft.com> wrote

You have to define this in your create table statement, or you can alter the
table outside of DTS in EM, then you can use the enable ident insert.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Margarita" <anonymous (AT) discussions (DOT) microsoft.com> wrote