I have a DTS script that is loading a table from an external data source. What we are doing now is loading a temp table which has a plain text password, using the SQL Server encrypt() function on that field, and then moving it to our production table.

Now we have another encryption procedure we are required to run, and it exists in a .dll file. Can I just run an ActiveX Script Task that calls this .dll to encrypt the password? Is this a recommended practice?

Thanks in advance,
Mike