We have to send some PHI (personal health information) out to a vendor, and they will return something back. Currently, they are asking for only the PII (personally Identifiable Information) columns to be encrypted, then exported as a flat file.

The data will look something like this:

first_name,last_name,Heart_rate

Ian C.,Weiner,80

Anita,butterscratch,92

Question: How would you encrypt first_name, last_name but leave Heart_rate as it is?

"Do it differently" is an acceptable answer - it seems like a weird request to me.

We are currently on SQL Server 2014, SSIS 2015.