I am new to SSIS. I am trying to create & load the Following tables in my new database using AdventureWorksDW2008R2 schema:
I have to load data from AdventureWorks2008R2 sample tables & flat files
I could not find all the colomns of dimensions I am creating to load from AdventureWorks2008R2 tables, particularly the foreign names.
Also after creating the above dimension how to create facts out of it. How would I create PK and FK in SSIS.
View Complete Post