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 |
|
sumitava20
Starting Member
4 Posts |
 Posted - 2014-04-18 : 02:04:05
|
| The requirement is that the data in certain columns in a table need to be encrypted after data is loaded through SSIS and later on need to be decrypted so that these values can be used in calculations in a stored proc. My questions are :- Do I add new columns to the existing table to hold encrypted data in varbinary or something? What can be the appropriate data type that can hold both the encrypted value and the value after decryption in the same column?Do i move out these fields in separate tables? Will it help me in any way ??how can I approach this problem of encryption and decryption of cell values. bdw i am using sql server 2008R2 and original data type suggested for these fields are money. |
|
|
sumitava20
Starting Member
4 Posts |
Posted - 2014-04-18 : 02:51:47
|
| I desperately need some quick suggestions |
 |
|
|
sumitava20
Starting Member
4 Posts |
Posted - 2014-04-20 : 00:10:17
|
| Does anyone have any idea on this? I could clearly do with some help !!! |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
|
|
|
|
|
Encryption and decryption of column values