Thanks for the advise.

I will do so.

In this case I'm Truncating and re-loading the Data from an AS400 nightly.

Thanks again. 🙂

Why is it necessary to open a new session?

I'm having bad luck.

The first time I execute the following code I get the decrypted SSN:

CREATE TABLE dbo.Name_and_SSN

(Full_Name VARCHAR(50),

CLEAR_SSN VARCHAR(12));

--point_ctl.agent_support.tax_id_number

--and point_cyp same table

INSERT INTO dbo.Name_and_SSN (Full_Name,CLEAR_SSN)

VALUES

('Egor Mcfuddle' ...

Eirikur Eiriksson (7/17/2014)

---

Oooops! Hate to be the one to tell you but...

I did not open the Key in the new window.

That was the problem.

Thanks for all the help.

tripleAxe (7/17/2014)

---

You said in an earlier post that you re-created the key. How did you do that? If you dropped the key then I suspect that is why...

So the scope of the key is limited to a session.

That is why it does not work.

If anyone knows what I need to differently so decrypt from another session it...

I recreated and opened the key. It decrypts from the same session but when I go to another session it list null.

That was a great example.

I have a little problem.

I'm going to load the data and encrypt it in an SSIS Package. Data Transformation followed by an Execute SQL Task to...

Eirikur Eiriksson (7/16/2014)

---

This sample is kind of a walk through, add column, update with encrypted, mask the clear text etc..

😎

USE tempdb;

GO

CREATE TABLE dbo.Name_and_SSN

(Full_Name VARCHAR(50),

CLEAR_SSN VARCHAR(12));

INSERT INTO dbo.Name_and_SSN (Full_Name,CLEAR_SSN)

VALUES

('Egor...

Thank you so much for your help.

I appreciate the criticism.

🙂

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...

Eirikur Eiriksson (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

I started out by asking a basic question about encryption.

I am Grateful for the help and I got my answer. Then I asked about the next...

ok, I'm sorry for causing any grief.

I have SSN's in a column in a table.

I want to encrypt those values.

That would be a simple update statement?

Thank you all for your...

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

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...