Hi,

I have a requirement to compare data between two tables in SQL Server.

What is the fastest way to do it using SSIS? There are approx 6~7 millions of records in each table.

My solution: Read both the tables and store the data in Object Type variable. Then run an except query. But I am stuck at except query part. How do I implement it?

Any other solution using SSIS is also welcome which can serve the purpose.

Regards,

Ayush

Why SSIS? Are they on different servers?

May be worth creating a hash to compare depending on size/number of columns

Yes, they reside on two servers.

The number of columns is also too much (132). Data size is 6~7 millions.

Runnning an except query on SSMS is taking infinte time creating blocks on the server.

So, i need to look for an alternate method.

Regards,

Ayush.

do a hashing based match

see example given here

http://visakhm.blogspot.ae/2014/06/ssis-tips-implementing-scd.html