Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS not respecting Indentity key
Message
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
DTS not respecting Indentity key
Miscellaneous
Thread ID:
00516538
Message ID:
00516538
Views:
50
Hi:

I'm using DTS to transfer data from one table to another. In the destination table I have an Identity Key set so that when the records are appended to the destination table, an identity key will be added. However, the transfer bombs on the first record saying it can't insert a null into this field. Obviously its not inserting the key. Any ideas why this is happening?

Thanx,
Charlie
Next
Reply
Map
View

Click here to load this message in the networking platform