Post reply

UPDate table using Ssis

  • July 9, 2008 at 5:39 am

    #122395

    Hi

    I have 4 tables ,all have same fields like emp_id,ename,joindate

    3 out of 4 table have same this 3 columns ,but have different data set

    table 1 have data of Janu'08

    table 2 have data of feb'08

    table 3 have data of mar'08

    i need to update the Latest information which are inside the mar'08 table ..

    means whtever the new rows are in mar'08 ,i neeed to update that in to feb table ,and wtever new rows in febtable need toupdate in janu table...so we have the latest info ...in 4th table.

    how to do with SSIS ?

    can you explain me just step ..or can you send me the Package,,if u ..

    thanks in Advance

  • July 9, 2008 at 9:19 am

    #840265

    crazy4learn (7/9/2008)

    Hi

    I have 4 tables ,all have same fields like emp_id,ename,joindate

    3 out of 4 table have same this 3 columns ,but have different data set

    table 1 have data of Janu'08

    table 2 have data of feb'08

    table 3 have data of mar'08

    i need to update the Latest information which are inside the mar'08 table ..

    means whtever the new rows are in mar'08 ,i neeed to update that in to feb table ,and wtever new rows in febtable need toupdate in janu table...so we have the latest info ...in 4th table.

    how to do with SSIS ?

    can you explain me just step ..or can you send me the Package,,if u ..

    thanks in Advance

    I am Designing a flow, correct me if I was wrong.

    step1: new rows of table3 -> existing rows in table2 + new rows coming from table3

    step2: new rows of table2 -> existing rows in table1 + new rows coming from table2

    step3: new rows of table1 -> existing rows in table4 + new rows coming from table1

    This is what you want?

    Thank You

  • July 10, 2008 at 6:52 pm

    #841191

    thanks for reply

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply