We've modified the OLEDB_NOPROVIDER error to return the name of the provider we failed to find. This will appear in the RC0 release of SQL 2008.
SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider SQLNCLI.1 is not registered. Error code: 0x0000000
This should help in debugging issues related to connection string upgrades.
Hi i am getting the same error when runing pakage on server (run fine from MY PC) I hade to change the build from 64 to 32 on server as Microsoft.ACE.OLEDB.12.0 64 bit where not available. I am Running SQL2008 SP1 and the problem is still there.
Stupid error Mesages... the Package could not open the SQL conncetion, how about having an error message like 'ACCESS DENIED' ......
Thank you for the constructive feedback.
I believe the error message you get when a SqlConnection fails is something along the lines of "could not establish connection". The error message mentioned in the blog post appears when the provider is no registered on the machine.