开发者

Migrating SSIS package from SQL Server 2005 to SQL Server 2008

开发者 https://www.devze.com 2023-01-03 20:57 出处:网络
Hi I am Migrating SSIS package from SQL Server 2005 to SQL Server 2008. The package ran successfully in sql 2005 using provider \"SQLNCLI.1\".

Hi I am Migrating SSIS package from SQL Server 2005 to SQL Server 2008. The package ran successfully in sql 2005 using provider "SQLNCLI.1". In sql 2008 I have changed the provider to "SQLNCLI10.1" it gave below error:

Error:SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The req开发者_Go百科uested provider "SQLNCLI.1" is not registered.

But I am using "SQLNCLI10.1" provider in my package as mentioned above. Please suggest me what could be the reason for this?


Is is possible that you have the connection string in a saved configuration? The provider is part of the connection string and if you have that in a saved config, it will override the connection string set up manually in the package. To check if you are using a config, right click on the control surface and select Package Configurations...

To see if this is the problem, uncheck enable package configurations if it is checked.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号