We are using Konesans checksum tool in a package we have (SQL 2005 running on Windows 2003 SP2). We are running a transformation in order to determine any changes before our overnight processing, however the checksum has suddenly started saying that every record is different, every day. I've done some checks and this is not true.
We are running in the 'original' mode which I know has some issues with SQL 2005 but I'm not sure what, I wondered if anyone could shed any light on this.
I've also built a little test application this morning and when I re-run it to output the checksum the values are the same, it almost seems to change daily.....
Any help would be great.