Trying to Bulk Insert SSN data into an always Encrypted column and is not working. Any guidance please.

Sanjay Kumar 0 Reputation points

I am having trouble Bulk inserting the SSN data from a simple SQL table to a table where I have an always encrypted column. I am not getting any right solution after googling around.

Please share if anyone has done similar kind of work.



SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,053 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
{count} votes