using merge statement in ssis package

Here is my situation.

I have got Table A in database DB1(sql server) and Table B in database DB2(sql azure) with same table structure. I need to compare the data in table A and Table B and add the missed records in Table B and als开发者_开发知识库o update table B.

Can anyone help me on how to do this in a SSIS Package using merge statement?

If you know how to write the merge statment in t-sql, just use an Execute SQL statement to execute it.

Please refer to the same type of question which i also asked earlier:

Merge two Table in SQL Server 2008

In your case write the fully qualified name of table means SERVERNAME.DBNAME.TABLENAME in this way.

Hope this help.:)