I am new to SSIS how to generate surrogate key? Any one can explain Step by Step?

ssuresh

HI Suresh,

Surrogate Keys: Which are system generated keys which has no meaning..it occupies less memory when compared to primary keys and others keys.

To generate surrogate keys we need to mention Identification Columns in the properties of the Primary key...one more thing is we need mention increment by one...then it will automatically generate the surrogate keys in the table.

With Maitri,
Maruthi..