Skip to Content
0
Former Member
Mar 23, 2009 at 12:14 PM

Want to use MS SQL Identity functionality on primary key columns

46 Views

We want to use the Database functionality in SQL Server, Identity, to preserve primary key integrety.

I can not find any information regarding the use of Identity columns in SQL Server in combination with Data Integrator.

Anyone that knows anything about this, and how this can be achived in BODI with the BODI transformation such as Table Compare, Key_Generation, Map operation and so on.

We are using Data Services 3.1 on a MS SQL Server 2005 platform, where target is a MS SQL Server 2008.