Surrogate Key is SSIS data flow transformation that assigns warehouse unique key,
also called surrogate key, to records from production system database.

Component directly uses one stored procedure which name can be set through SK Procedure property. This stored procedure is supposed to have output parameter which stores assigned surrogate key value. Stored procedure name is the only limitation of this solution: name, number of input parameters and surrogate key algorithm can be freely modified. Its usage is pretty simple: user only need to map transform input columns to corresponding stored procedure input parameters. Component installation comes with predefined stored procedure and table scripts which are support for correct component functioning. User is still free to change this infrastructure if it does not meet his needs. Pexim developed this transformation to solve surrogate key assignment problem in its own business intelligence solution. Therefore, component is not completely generic, but can be widely customized, through implementing surrogate key assignment logic that best meet user’s business intelligence solution logic. Also, this is not final release and is subject to change.

Important Note:
Pexim Solutios is not responsible for any damage that can arise during the installation and usage of this software.