how to copy identity flag using DTS?

[russland]

hi,

i managed to copy all the db objects i wanted to the target db. the only thing not okay is that it doesn't overtake the identity flag where it's set in the srouce db. i've got an ID column in each table. so you see... bad thing if that flag isn't set to IDENTITY=YES. thus, strange enough that he set the flag NOT NULL. any help on a clean copy setting the IDENTITY FLAG as in the source db?

FYI. i checked the following while copying objects:
-create destinantion objects
-drob destination objects
-include all dependent objects
-include extended properties

-copy all objects
-use default objects

thanks

 

[JBaileys]

You may consider setting your identity column for not for replication.

example:

[Custid] [int] identity (1,1) not for replication ...