Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2007-09-08 : 10:26:45
|
| I have an ASP VbScript website that uses a 3rd party ASP Encryption object to encrypt/decrypt credit card data. The data is encrypted on the asp page before it is inserted into the SQL Server 2000 db. The encryption object uses the plain credit card number and another number (which the page supplies - called the 'Valuer') to encrypt the number. The encrypted number and the Valuer are then Inseted in the table. To decrypt the number, the same process is used in reverse using the encrpyted number and the Valuer passed through the object.The problem I have is that I need to decrypt the encrypted numbers as part of a query in a DTS package, so that I can write the selected decrypted credit card numbers to a text file. I cannot get this to work. I realise that this needs to done using an ActiveX script at some point but I simply am not able to do it. Can someone possibly help please? |
|
|
|
|
|
Decrypt encrypted data in DTS