First published on MSDN on Dec 17, 2015
The released SQL Server 2016, currently available as
http://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/
, a...
Published Mar 25, 2019
Version 1.0
Blog Post
After creating the package using the Microsoft.Data.SQLclient driver, I can connect successfully to the database, I can preview the data from the encrypted table in the ADO NET source component however when I try to run the package, it throws the error message: ADO NET Source has failed to acquire the connection {...} with the following error message: "Could not create a managed connection manager.".
I am using VS2022 and the database target is SQL Server 2022.