Delegation: Bulk Insert failed when executed from SSRS dataset but success from SSMS
I'm glad I asked what your end goal was. I was going to reply in a comment but it turned into too long of a response.
Your best bet is honestly to close this question and ask a new one on &quot;best ways to implement data encryption and obfuscation across multiple databases?&quot; with details on each type of data system you're using. There's a multitude of ways to accomplish what your customer wants with out-of-the-box features of SQL Server without rigging together a roundabout solution.
One of them is Encryption another is Dynamic Data Masking, and finally understanding proper Permissioning in SQL Server are all standard and potential ways to hide your customer's data, even from developers.
All three of those previously mentioned plus many other features, are applicable to the databases that are utilized by the systems you mentioned (SQL Server version dependent).