Goal: Fill data in the table Fact_buy. Problem How should I make a data transaction based on the sql code below to the table Fact_buy in SSIS? The sourcecode below is indirectly that you cannot make a transaction direcly in the table Fact_buy for instance you have the data of store_id that is located in the table Dim_store. You need to retrieve data of id_dimstore and id_diproduct in order to make transaction to the table Fact_buy What I believe is that you need to make more complementory by using additional component, sql etc in order to complete the transaction to the Fact_buy. SELECT store_id, product_id, buy Id, date FROM Store, Buy, Product // Fullmetalboy

Hi, Have a look at this post in my blog: http://thebipalace.wordpress.com/2011/06/27/populating-data-warehouse-using-ssis/ It must help you do the job. Cheers.http://thebipalace.wordpress.com