Ever wondered how you can generate surrogate keys in a SQL Server Integration Services (SSIS) data-flow?
Well here on SQLIS.com is just 1 method you can use - the script component! Let me know if this works for you or not.
-Jamie