Post reply

Need help in referring the table of different connection in data flow

  • March 10, 2008 at 11:01 pm

    #120455

    I am working on data migration from custom database to TFS database.

    Here is the scenario where I need a help:

    Source: MyDB.Person table (SQL 2000) (SID Unique Key)

    Destination: TFSDB.Person table (SQL 2005) (SID Unique Key)

    Table to be referred before transferring the data: TFSDB.Contacts. This table contains some records already. It has SID as unique key which is actually a person ID.

    Logic to be implemented: Before transferring the record from source table, I need to first look into TFSDB.Contacts table. If it has the record with same SID then I need to skip the source record.

    I tried out using LOOKUP transformation in Data flow but it did not work. Can anybody have any idea how to do it?

    Thanks.

    Nishant Desai.

  • March 10, 2008 at 11:05 pm

    #787775

    When you say the lookup transformation failed, how did it fail? How were you trying to use it?

    😎

  • March 11, 2008 at 12:51 am

    #787802

    I took lookup component in data flow and used TFS database connection and selected contacts table and SID field of it but it does not give me any functionality by which i can prevent adding the record from source if SID is there in TFS.Contacts table.

  • March 11, 2008 at 3:24 am

    #787839

    To implement this you can create one extra table , and transfer all the records from your source to that table and after completion of this you can write the insert statement to make a join with your source data (which is now in extra table) and your actual data and insert those records whose SID in not exists in actual data......

    Thanks,

    Amit Gupta

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

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