i have some tables from excel using data flow for dimensions and OLTP table. Now i want to create sales fact using some dimensions table, how could i create the sales fact using ssis? thanks

First design your data warehouse and accordingly you can load your fact tables.. before loading the fact table load your dimension tables... your question is not clear, can you please give some more details.. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/