I need to get the Hash of the files content. I know SSIS gets the checksum for every row in the file. But what I need to get is the Hash of the content of the file. So, when I insert a log of the file processed and can insert the FileName and its hash (content of the file).
This will help me when I re-run the package and this package read the same filename, I calculate the hash of the content and then I compare this hash vs. the one that storage in the log table, so if the hash is the same I wont process anything, but if the hash is different I will process the file.
Anyone has experience with this?