August 25, 2016 at 7:16 am
I recently installed Integration services and the SSIS SDK on my machine so I could try to build some custom SSIS tasks for myself. However, since doing this, none of my ADo net connections work. I have a couple of packages I run on my development machine that use excel and Dbf connections.
The error I am getting for excel connections is [p] as follows :[/p]
[Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[p]For my DBF connections I get the following error :[/p]
[ADO NET Source [2]] Error: ADO NET Source has failed to acquire the connection {08ABDE86-E8AB-49B5-AD63-452AB6B8EA23} with the following error message: "The 'VFPOLEDB.1' provider is not registered on the local machine.".
[p] I am guessing this is a result of installing integration services locally. is there any way to fix this without removing the local integration services, or reinstalling SSDT? If not, Can I only uninstall the local copy of SSIS and keey the SDK so that I can continue to attempt to build custom SSIS tasks? [/p]
August 25, 2016 at 7:41 am
Fixed. Issue was related to run64bitruntime getting set to true.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply