We are testing out using always encrypted and the developer has written a SSIS Package to load a table with an encypted column. It works fine when he runs the package from his local workstation. When we deploy the package to our server and run it using an agent job running under a service account the package errors with a message that it can not find the certificate with the proper thumbprint in certificate store 'My' in certificate location 'CurrentUser'.
Server is Windows 2012. I've imported the certificate to pretty much every store location I can think of. Putting it in the sql server or sql agent service account personal certificate store didn't work. Anyone know where the correct store location is?