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 requested 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?