Hello.

I'm working in DTS from a couple of days. I have a data without an ID column and i'm importing it with DTS but want to add an ID column. I set this column with 'uniqueidentifier' type and mark a "Enable identiti insert" in Transform Data Task properties but don't work. It says that can't insert NULL into ID column...

How do this ?

Sorry, but i just figure it out.

I change type of ID at int and add a 'counter' variable... so simple ;)

Hey,

A uniqueidentifier is different. The field is actually a GUID, and you got to use the NewID() to create a new guid for the row. If you want identity insertion, use an integer type (int, bigint) or numeric (numeric and decimal can specify a custom length).

Brian