Checksum calculation
Plz some one help me in doing this....
We get two types of files .dat and .chk files
.Chk file contains the checksum value of the .dat file
Our task is
1) Create a SSIS package using Stored procedures
Have to calculate the checksum value after we get the data and compare with the ckecksum value we got from them
Clean data Goes to one File and the other data goes to Error File
All the cleaned data should go in to the table with insert and update commands
if we get the same number we have to update the table
if we get the different number we have to insert in the table
|