capicom in dts
I am trying to use capicom in a dts to encrypt some fields that I'm putting into the database. I am getting the following error:
Error Source = Microsoft VBScript runtime error
Error Description: object required: 'server'
My code is:
set message = server.CreateObject("CAPICOM.EncryptedData")
message.Algorithm.Name = 1 'CAPICOM_ENCRYPTION_ALGORITHM_RC4
Do I need to add some kind of definition for the "server"? Any help would be greatly appreciated. Thanks