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 packages have been re-deployed.

IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = 'AES256SecureSymmetricKey')

BEGIN

CREATE SYMMETRIC KEY AES256SecureSymmetricKey

WITH ALGORITHM = AES_256

ENCRYPTION BY PASSWORD = N'StrongP@ssw0rd!';

END

OPEN SYMMETRIC KEY AES256SecureSymmetricKey

DECRYPTION BY PASSWORD = N'StrongP@ssw0rd!';

UPDATE POINT_CTL.AGENT_SUPPORT

SET ENCR_TAX_ID_NUMBER = EncryptByKey(Key_GUID('AES256SecureSymmetricKey'), convert(varbinary(68), TAX_ID_NUMBER))

,TAX_ID_NUMBER = '**********';

CLOSE SYMMETRIC KEY AES256SecureSymmetricKey;

Then I needed to do the same for the same table name in a different schema.

I was changing the name of the symmetrict key from AES256SecureSymmetricKey to AES257SecureSymmetricKey.

That did not work so I changed it back to AES256SecureSymmetricKey and it worked like a charm.

Thank for all of the help.