none
CREATE A TABLE DESTINATION OUPUT BASED ON THE CONDITION OF ANOTHER TABLE DATA

    Question

  • Hi

    I am a newbie for ssis.

    i would like to know,

     how would i create an output or cache transform  with a condition taking the data from another table.

    An example

    Let say i have two table

    Employee table which consists of  name, department, dateofbirth

    System processing date table which consists of branch, business date

    i would like to display the information of the employee from the employee table which take the condition of the employee table dateofbirth > system processing date table business date.

    If any kind people that could help on this

    thank

    Regards,bruce 


    brucelim

    Tuesday, July 30, 2013 2:07 AM

All replies

  • What do you mean by 'display the information'? Do you want to join both tables?


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Tuesday, July 30, 2013 6:48 AM
    Moderator
  • Hi

    Thank for the reply.

    i would like to

    1) display information of one table (table A) but depending on a criteria of a field of the table has an value less than the field of the other table (e.g. display table A information where one field of table A is greater than a value a field of table B)

    2) display information of two tables (A and B) with condition of a complex formula based on the critieria of the existing table.

    Thank

    Rgards,

    bruce


    brucelim

    Wednesday, July 31, 2013 1:00 AM