Hi,
Trying to get a particular SSIS is package working - while running the Package Installation wizard a package is reported with the following errors:
- AcquireConnection method fails with error code 0xC0202009
- Then Lookup fails validation and returns code 0xC020801C
The odd thing is the Lookup does not exist in the package, it did exist at one point but was deleted.
I have tried searching the XML and can't find any reference to the Lookup
Any suggestions appreciated...
Thanks,
John

AcquireConnection Error - Lookup Component
Shanti Johnson
Any ideas how
The steps I've tried are:
Delete all the packages in the server file system store
Check the local package for the Lookup (not found)
Rebuild the solution.
Double click the manifest to deploy on the server to a file store with the validate option turned on.
Validation warning above occurs.
If I open the package in notepad and search for the name of the lookup I don't find anything
Jay Wise
profadv
You may want to try a brute force here and search for all files with extension .dtsx on your machine. You could find some you do not know about (VS sometimes makes copies). If you do, see if any of them is the troublemaker.
HTH.