Last post Feb 11, 2015 03:12 AM by Michelle Ge - MSFT
Feb 10, 2015 01:23 PM|kanmai|LINK
I trying to do data transfer..from SQL to DB2, in one of the table in DB2 there is 2 encrypted column, I need to encrypt that column in SSIS and insert it in to DB2.. or how to use ENCRYPT_RC2 in SSIS?
SQL ----------> SSIS
Encrypt and do transformations ---------->DB2
Any help Appreciated..
Feb 11, 2015 03:12 AM|Michelle Ge - MSFT|LINK
So far as I know, if you want to insert encrpt column into DB2, I think first you need to decrypt it then insert it.
With the encryption, we must first open and decrypt the symmetric key.
For more information and steps, please refer to the link below:
Hope it's useful for you.