is it OK to use SQLNCLI10.1 as a provider for SSIS 2008 R2 to connect to SQL Server 2016 database(s) in my job script.
When I am running job I am getting error the provider is not available or the provider is not registered like that I am getting error.
When I am executing packages manually ,all packages are executing successfully and data also loading in to 2016 server data base, but I am executing through sql agent job only iam facing provider SQLNCLI10.1 is not registered like that error iam geeting.
In my job script iam using provider SQLNCLI10.1 .
Could any one please help on this for resolving this issue.