Exact Name Matching In SSIS?

Question

Hi,

How to compare two tables in ssis against the exact matching on name column in both tables. Source table have 1.2million records. Please suggest me the best performance approach.

Thanks

Answer 1

Are you just trying to verify that the data is the same or actually doing something with it?  If you are just doing a data compare then you can do that with some versions of visual studio.

http://www.mssqltips.com/sqlservertip/2098/sql-data-comparison-with-visual-studio-2010/

You can also use SQL2012 SSDT (SQL Server Data tools)

Or AdeptSQL or Redgate

---

Chuck

Answer 2

Hi cmk1,

If you meant to check if a record exists, if so update else insert? In that case, you can use LOOKUP component and the CONDITIONAL SPLIT component to achieve it, please see: http://consultingblogs.emc.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

And you can also use Checksum Transformation to do comparison, please see; http://www.ssistalk.com/2007/03/09/ssis-using-a-checksum-to-determine-if-a-row-has-changed/

Thanks,
Eileen