Re: record hash

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.


.

Relevant Pages

  • Re: use hash in a list
    ... I am going to write a program that is able to generate a list for employee ... Charles NY English ... > What does "hash inside a list" mean? ... in that an array involved in an assignment will tend to ...
    (comp.lang.perl)
  • Re: A little help on perl coding..
    ... The key for the primary hash would be the ... employee uid, ... Each secondary hash will have entries with keys ...
    (comp.lang.perl.misc)
  • Re: [SLE] Re: [suse-kde] key server list
    ... Hash: SHA1 ... > But as long as my employee is using M$ LookOut it's impossible for me to ...
    (SuSE)
  • Re: Two Sets of Variables
    ... Sorry - made hash of explanation ... Need to do employee and department totals and grand total at end. ... Grand total at end (in report footer) always works well. ...
    (microsoft.public.access.reports)
Loading