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

CHECKSUM in SSIS Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 1:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 11, 2013 8:39 AM
Points: 58, Visits: 606
Hi,

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.

Thanks,

Nic
Post #1471466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse