Lynn Pettis (7/27/2014)

---

Welsh Corgi (7/27/2014)

---

I have a Wait Type Suspended Wait Type CXPacket Request Command Insert going on for 7 hours.

It is the only active process hat is active.

I do...

Lynn,

Thanks for all of the positive feedback.

Lynn Pettis (7/21/2014)

---

Welsh Corgi (7/21/2014)

---

Hi Tom the script that provided me still works.

USE tempdb;

GO

-- TRUNCATE TABLE dbo.Name_and_SSN

-- DROP TABLE dbo.Name_and_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...

Accidental post.

Accidental post.

Accidental post.

I should have mentioned that I was executing the commands on line at a time.

:blush:

Gazareth (7/21/2014)

---

I'm no expert in this, but I think if you drop the key in the first query, then you won't be able to decrypt anything encrypted with it, so...

I got it to work. I went to on old version of the package and copied and pasted it into SSMS. Reloaded the table ran the script and it executed.

The...

Hi Tom the script that provided me still works.

USE tempdb;

GO

-- TRUNCATE TABLE dbo.Name_and_SSN

-- DROP TABLE dbo.Name_and_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'...

TomThomson (7/19/2014)

---

Welsh Corgi (7/18/2014)

---

I'm having a weird problem.

I do not have it in one AS400 Library within SSIS but when I go to another I get an error that the...

s soon as I open The key it fails in SSIS but it works inSSMS?

It was not but is now returning null values from SSMS. I did was change the encryption key.

I'm having a weird problem.

I do not have it in one AS400 Library within SSIS but when I go to another I get an error that the column does not...

Thank you Tom for all of your advise, very much appreciated.:-)