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