Two Tables Checksum Transformation

Question

Hello Experts,

I have two tables. Table 1 has five columns and table 2 has 10 colunms

Table 1 columns are...ColumnA, ColumnB, ColumnC, ColumnD, ColumnE.
Table 2 columns are...ColumnA, ColumnB, ColumnC, ColumnD, ColumnE to ColumnJ

Table1 -> ColumnA value = Table2 -> ColumnC

Table 1 has 100 rows and table 2 has 300 rows. First 200 rows in Table 2 has ColumnC Null values...now SSIS Controls.

1. I wrote two "OLE DB Source". One is called Source1 and other is called Source2. Source1 pointing to table1 and Source2 pointing to table2
2. Both have "IsSorted" to True
3. Both have ColumnA Table 1 SortKeyPosition to 1 and ColumnC table 2 SortKeyPosition to 1
4. Now when I run it, the checksum transformation, shows different checksum values for ColunmA and ColumnC even though they both have same values,

What am I doing wrong? Your help is highly appreciated.

If I remove NULL rows and keep 100 rows in table1 and 100 rows in table2 - then checksum values are matching...thats not what I want..i want check sum to come same value, irrespective of the rows position? Is it possible to do?

Thanks,

Suresh

Answer 1

Any kinds of reply is highly appreciated...????

Answer 2

HI Suresh
I dont have the check sum transformation
But if u could share the business rule for the ETL of ur package then may be we can help you ....
from 2 OLE Db source what exactly u want to direct in ur destination/S...
-- Kunal