Lynn Pettis (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing record to the encrypted value so...

Thank you so much for your help. I appreciate it.:-)

Lynn Pettis (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing record to the encrypted value so...

Ed Wagner (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing record to the encrypted...

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing record to the encrypted value so I need...

ok how can I delete the mater and subordinates?

Thanks.

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing record to the encrypted value so I need to add an addition...

Thank you so much Sir.

TomThomson (7/16/2014)

---

I seem to have missed something out in the decryption. If you change

SELECT CONVERT(varchar(128), DecryptByKey(SSN)) as Plaintext_SSN

...

I changed the Data Type.

I revised Tom's code for I had errors with the variable names that I used.

I can't get it to store the encrypted value.

CREATE TABLE Name_and_SSN

(Full_Name VARCHAR(50),

encodedSSN...

Tom, thank you very much for your help.

If you were to execute the code that I posted you will find that it does not not store a value in the...

I opened the key and I was trying to write not read.

If you would be so kind as to execute my code you will see what I mean.

oops. I did something wrong the value of the SSN is Null.:unsure:

I was able to Insert the Record.

What do I need do to read the unencrypted value?

--First create a certificate, access to which represents permission to decrypt the SSN column; lets...

Thank you.

Could you please included the creation of the Key etc?

CREATE TABLE Name_and_SSN

(Name VARCHAR(50),

SSN CHAR (9))

OPEN SYMMETRIC KEY SSNKEY DECRYPTION BY CERTIFICATE SSN_Cert;

INSERT Name_and_SSN(full_name,encodedSSN)

values(@name, EncryptByKey(Key_GUID('SSNKEY'), convert(varbinary(128), @ssn)));

update...