August 28, 2011 at 9:53 pm
There is parent package calling another package which is set inside a loop process task. Package works after removing outside the loop and fails when it inside the loop task. Error message is pretty generic "The requested OLE DB provider SQLNCLI.1 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components ......". Is there any option inside loop process task to make this work? Thanks
August 29, 2011 at 1:21 am
This was removed by the editor as SPAM
August 29, 2011 at 10:26 am
I did try, same error. Few more details and questions on the link which you sent( actually i have already tried that before may be i should i have mentioned it).
i) in my ssis i am using config files , so i have change the client in there but still no luck
ii) the article which you sent me is form 2007, and sql 2008 R2 wasnt yet released by then.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply