Hi,

I have a user table that's now storing username and password in clear text.
I'd like to replace the current password field with a new field that stores
the password in hash format.

This table is used in a web application. I'll modify my pages to hash the
submitted password for comparison with the hash in the database. But is there
a way to use DTS to hash the existing clear text password entries and
populate into the new field?

Thanks,
ywb.

Hello WB,

Not out of the box no. You would either need pass the hashing routine function
to DTS when you write the value (this would be an external call me thinks)
or you could build a custom transform in which you could do your hashing.

Allan