March 30, 2012 at 12:21 am
hi all,
I have 3 flat file source cust_det, store1_sales,store2_sales
Cust_details_source
cust_id,cust_name,cust_since,cust_city
1000,XYZ Corp,10/22/07,Dallas
1001,ABC Corp,11/20/08,New York
1002,Citi Bank,12/23/07,Dallas
store1_sales
store_id,sales_id,sales_date,cust_id,Amount
1, 10,01/01/12,1000,4500
1,11,01/01/12,1001,300
1,12,01/01/12,1002,500
1,13,01/10/12,1000,600
Store2_sales
store_id,sales_id,sales_date,cust_id,Amount
2,10,01/01/12,1002,8000
2,11,01/01/12,1002,200
2,12,01/01/12,1002,150
2,13,01/01/12,1002,400
My target should looks as below structure
cust_id,cust_name,Store_id,sale_date,Amount
Can anyone help on this
March 30, 2012 at 12:50 am
Think Import to a table then from there you can join those and get the required result...........
March 30, 2012 at 1:07 am
from ssis import this three different file into three tables then from join those table you can get your desired result.
let us know if you want more help .
Raj Acharya
March 30, 2012 at 1:09 am
Pradyothana Shastry (3/30/2012)
Think Import to a table then from there you can join those and get the required result...........
+1
You can merge the contents of store1_sales and store2_sales in the SSIS dataflow using the UNION ALL component. That way you'll need to do only one join in SQL Server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply