Consider changing the PROVIDER in the connection string to SQLNCLI11

Consider changing the PROVIDER in the connection string to SQLNCLI11

Issue: Consider changing the PROVIDER in the connection string to SQLNCLI11

Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The Acquire Connection method call to the connection manager ".\inst1.ServiceReportingDB" failed with error code 0xC0209303

Solution: Please follow the below step to resolve the issue.

You do it individually by clicking on the connection and editing the Connection String property, or bulk edit .dtsx files with Find/Replace.

Provider=sqlncli.10.1

with

Provider=sqlncli11

 

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.