[dba-SQLServer] DTS

Found it: Options - Allow Identity Insert.

David

At 20/02/2004, you wrote:
>SQL 2000 Enterprise Manager
>
>I am putting together a DTS package that copies live data into my test 
>database.  I have a data transformation set up for the tables and all the 
>data seems to copy over except the Identity field.  Instead of copying the 
>old contents it gives them new ID numbers.  This is a problem because when 
>I try to copy other tables that have relationships the ID's don't match.
>
>When I look at the transformations tab, and open the options for the field 
>transformation the description shows "Copy the contents of the source data 
>unchanged to the destination."  (yet is isn't).
>
>Any clues as to why this problem (or better still a solution).
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>25 Cunliffe St, Churton Park
>Wellington, New Zealand
>Ph/Fax (877) 456-1205
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax (877) 456-1205