>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

Mike,

You can call your activex

Dim sMypassword as string
sMypassword = "goodasitget"

Dim oEncryption as Object
Set oEncryption = CreateObject("my.encryption.dll")

Dim sEncrypt as string
Dim sDecrypt as string

sEncrypt = oEncryption.Encrypt(sMypassword )

Msgbox(sEncrypt)

sDecrypt = oEncryption.Decrypt(sEncrypt)

Msgbox(sDecrypt)

PS - The dll has to be registry on the machine running the DTS package.

Evans, Carl