Hi,
I got 5000 rows in source and when i am sending the data to destination it has to create a sequence generator number for each row.
Can any one help me which transformation do i need to take for doing this in SSIS.
Row Number Transformation(http://www.sqlis.com/default.aspx?93)|||
Alternatively you can also look the following articles
Surrogate key generation in SSIS @. http://www.sqljunkies.com/WebLog/sqlbi/archive/2005/05/30/15684.aspx
Generating Surrogate Keys @. http://www.sqlis.com/default.aspx?37
Thanks,
Loonysan
http://mystutter.blogspot.com/
No comments:
Post a Comment