I need bulk insert to a Always Encrypted table using SSIS Bulk insert task because if it is minimize the modifications for existing packages. Otherwise it will be change for all Bulk insert tasks in existing packages.
Asked
Active
Viewed 364 times
0
-
Do you get an error when you try? What is the error? – Tab Alleman Jan 05 '18 at 14:47
-
Take a look at these links, they might be helpful: https://dba.stackexchange.com/questions/160577/is-it-possible-to-bulk-insert-data-into-a-table-that-has-columns-encrypted-with – digital.aaron Jan 05 '18 at 20:06
-
https://www.mssqltips.com/sqlservertip/4162/writing-always-encrypted-data-with-integration-services-2016/ – digital.aaron Jan 05 '18 at 20:06