> i am trying to find a way to calculate record hash something like crc
> in
> order to identify if record send to me is a modified record or not.
> for
> example i have a record that has employee id, name, phone(in reality i
> have
> to deal with tables that have over 200 columns). so if i have a way to
> calculate hash for the original record and hash for the new record all
> i have
> to do is join on employee id and compare hash. if it matches record is
> the
> same and the oposite.
> i was able to have this approach implemented with informatica and it
> worked
> very fast and reliably. my question is there something like that
> available
> for dts. we are using 2005 server

"Allan Mitchell" wrote:

> Hello gremlin321,
>
> In your post you say "For DTS" but then say "We are using 2005 server"
>
> If the last part is true then are you using SSIS. If you are then look here
>
> Checksum Transformation
> (http://www.sqlis.com/21.aspx)
>
>
> --
>
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
> > i am trying to find a way to calculate record hash something like crc
> > in
> > order to identify if record send to me is a modified record or not.
> > for
> > example i have a record that has employee id, name, phone(in reality i
> > have
> > to deal with tables that have over 200 columns). so if i have a way to
> > calculate hash for the original record and hash for the new record all
> > i have
> > to do is join on employee id and compare hash. if it matches record is
> > the
> > same and the oposite.
> > i was able to have this approach implemented with informatica and it
> > worked
> > very fast and reliably. my question is there something like that
> > available
> > for dts. we are using 2005 server.
>
>