Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-03-25 : 01:50:26
|
| Hi,I could see most of the blog written for generating the surrogate keys. My question is, why they dont want to go with the IDENTITY function available in the SQL Server. Just defining the identity at the column level ensures that the number gets auto incremented with no headache in writing scripts using Script Component. Since I'm new to SSIS, I'm wondering why people use always Script component to generate Surrogate key. Any advantages in using that transformation.Thanks in advance |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-25 : 07:34:03
|
| Identity values only apply to one table, and have limitations in how values are generated. If you have a multi-table ETL, or more esoteric key generation requirements, then using the component would be a better solution. |
 |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-03-26 : 01:41:58
|
| You mean to say that user defined key can generated using Script Component and on the other hand, the identity can be defined for all dimension table if you wish, where script component may not be used. Please correct me if i'm wrong. |
|
|
|
|
|
|
Surrogate keys