The title says it all. I have dimension tables with the surrogate keys and staging tables. Currently when I'm creating the fact tables out of the staging tables I'm using subqueries in the OLE DB source select command to get the surrogates. However,
this isn't possible always and updating the fact table afterwards doesn't work either without having a temp table. So, is there a way to do this with SSIS transformations?
View Complete Post