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.

The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully

The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully 

Issue: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully

Solution: Ensure to follow the below step.

1.   If you are using 2008 or later you can try the below steps

Set the DelayValidation field to "TRUE"

2.   If you are using 2005 you can try Install hotfix from the below link

       http://support.microsoft.com/kb/932557

 

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.