Retreiving encrypted data from an external MS SQL DB during Autofill KW Set Action

[Greg_Kinne4]

I have an external db that I need to execute a SQL stmt against during an Autofill KW action (during indexing in Scan Queue).  The SSN field is encrypted in the external MS SQL db.  I can manually retrieve the encrypted SSN using the following TSQL command.  Can I place this code in the SQL box in the External Autofill KW set with parameters just as I would if I just used a simple SQL Select stmt?

USE Cusomer_Keywords

GO

OPEN SYMMETRIC KEY KWTableKey Dectyption

BY CERTIFICATE EncryptKWCert

SELECT CONVERT(NVARCHAR(50),DECRYPTBYKEY(EncryptedSSN)) AS DecryptedSSN

FROM KWData WHERE Last_Name =  
'Smith' 

GO

 Thanks

[John_Anderson4]

Have you tried it?

[Greg_Kinne4]

No, I'm just being asked for requirements purposes.  I'll give it a try if that's the only way I'll find out.

[John_Anderson4]

I haven't tried, but my gut tells me it probably won't work. I figured it would be fastest to just throw it into a test system and see if it works.

[Greg_Kinne4]

Ok, I'll post back here after I test it.  If it doesn't work, is there an alternative?