Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

Improved error messages about missing OLEDB providers

SSIS-Team's avatar
SSIS-Team
Copper Contributor
Mar 25, 2019
First published on MSDN on May 22, 2008

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 http://blogs.msdn.com/mattm/archive/2008/05/21/package-upgrade-connection-strings.aspx .

Updated Mar 25, 2019
Version 2.0
No CommentsBe the first to comment