Post reply

How to compare tables dynamically

  • January 20, 2014 at 7:19 am

    #1681533

    vinodhkumargv (1/20/2014)

    please any one help in this

    or

    suggest me for different approach..

    I'll go for the second option. 😉

    It's not clear from your question whether you have the 'emp' and dept' tables twice (once per database) or the 'emp' table in one database and the 'dept' table in another, but essentially it makes no difference to what I'm about to say.

    If you want to compare data or check that data in one table exists\does not exist in another table (in the same database or a different database), you can use the Lookup component within a Data Flow Task. You will need to specify a column to match on, i.e. a column that is present in both tables and then you can route matching data down one path and non-matching data down a different path.

    You will also need to set up Connection Managers - they contain connection string info - for each database.

    Does that help?

    Regards

    Lempster

Viewing post 1 (of 2 total)

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