SqlBI.eu

Table Difference 2.0

Guys, the next version of TableDifference is on the way, please check the call for beta test to participate to the beta test phase of the deploy.

Moreover, if somebody has an install script for SSIS data flow components and would like to share his experience with me to provide an installer... I'll be glad to get in touch with him/her, TableDifference definitely lacks an install program and I do not have much time to write it from scratch.

Written By: alberto.ferrari
Date Posted: 12/17/2007
Number of Views: 1304

Comments

Dipti Patil Says:

4/21/2008 5:12:53 PM

Excellent tool! Much better than the slow SCD transform.
I do have one issue though. I am retrieving my source data through SQL statements. E.g. Select EmpId, EmpName, 1234 AS Syndicate From EmpData
When I pass the data flow to the Table Difference component, it chooses to ignore the hardcoded field - Syndicate from both the old and new sources.
I get the following error message:
Column Syndicate From NEW has been ignored.
Column Syndicate From OLD has been ignored.

Is there a work around for this?

You must be logged in to submit a comment.

Return