Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Source and Target checksum values are not matching Expand / Collapse
Author
Message
Posted Tuesday, October 8, 2013 8:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:45 AM
Points: 20, Visits: 42
Hello,

I found this article really interesting. I implemented this approach using SSIS 2012 in slightly different way. Instead of storing the hash value in target table, I have computed it in the package using another script task and compared this hash value with hash value from source. However, the hash values from source and target are not matching even when there is no change in source data. Not sure why this has happened. I verified that input column sequence is same for both script tasks i.e. I have ticked the inputs columns in same order for source and target script tasks.
I have attached screenshot of the package. Any help is appreciated..!!
Thanks in advance..!!

~
Swapnil

Post #1502644
Posted Tuesday, October 8, 2013 8:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:45 AM
Points: 20, Visits: 42
Hello,
I found this article really interesting. I implemented this approach using SSIS 2012 in slightly different way. Instead of storing the hash value in target table, I have computed it in the package using another script task and compared this hash value with hash value from source. However, the hash values from source and target are not matching even when there is no change in source data. Not sure why this has happened. I verified that input column sequence is same for both script tasks i.e. I have ticked the inputs columns in same order for source and target script tasks.
I have attached screenshot of the package. Any help is appreciated..!! :)
Thanks in advance..!!
Post #1502645
Posted Tuesday, October 15, 2013 11:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:45 AM
Points: 20, Visits: 42
I resolved the issue. The script task concatenates the input columns based on order in which they appear in available input column list and not in the order in which they appear in the selected column list So, the order in which we tick available columns to add them to selected columns list is not important .
Post #1505069
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse