October 21, 2014 at 9:35 am
I am getting the following error when I try to connect to a db snapshot. I noticed that the source db is restoring. Could this be why Im getting the error?
The package "MyPackage" Task: Provider Specialties Load failed with the error:
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MyConnectionMgr" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
component "MyOLEDBSource" (134) failed validation and returned error code 0xC020801C.
One or more component failed validation.
There were errors during task validation.
October 21, 2014 at 9:40 am
What happens if you try to connect directly from SSMS?
-- Gianluca Sartori
October 21, 2014 at 9:42 am
I can connect and execute the oledbsrc tsql query. Is it possible the datatypes aren't the same?
October 21, 2014 at 9:45 am
I am able to run it locally on my laptop but not when I deploy to server. Server login doesn't have access?
October 21, 2014 at 9:51 am
If the production server is logging failed logins, you should find the reason in the errorlog
-- Gianluca Sartori
October 21, 2014 at 10:27 am
was a permissions issue, thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply