bulk insert into a staging table, then do a single insert from the stage table into destination table like this:

open symmetric key ... decryption by certificate ...

insert into secret(id,ssn)

select id, EncryptByKey(Key_GUID(...), ssn) from stage table

close symmetric key ...