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

Sanjay Kumar 0 Reputation points
2024-05-22T18:37:24.0333333+00:00

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.

Thanks,

SK.

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
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
{count} votes