Post reply

SSIS SCENARIO

  • March 30, 2012 at 12:21 am

    #391909

    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

    #1466761

    Think Import to a table then from there you can join those and get the required result...........


    - Pradyothana     http://www.msqlserver.com

  • March 30, 2012 at 1:07 am

    #1466767

    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

    #1466769

    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