question regarding migrating hashed password to MSSQL via MySQL ODBC version 3.51

------_=_NextPart_001_01C6CB79.EF7C1A8C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

***********************
E-mail has been scanned for content & viruses by Somerset Investors Corp.
***********-***********


I hope I will finally find answers here. I have successfully used the
MySQL ODBC driver through DTS to migrate our user db from MySql to Sql
Server 2000. The only problem is that the passwords in the user table,
which are entered as MD5 hashed values are not carrying over. DTS
automatically converts the column to varchar. If I change the type in
the Transformations tab of DTS to varbinary on the MSSQL side I get an
activex error (Error during Transformation 'AxScriptXform' for Row
number 1. Errors encountered so far in this task: 1. ActiveX Scripting
Transform 'AxScriptXform' encountered an invalid data value for
'Password' destination column.)

=0D

Has anyone successfully moved hashed passwords to a MSSQL database? Any
suggestions??=0D



------_=_NextPart_001_01C6CB79.EF7C1A8C--