Unanswered: SSIS Packages, MS Access is the source
so i have a SSIS package that loads data from an access db. it was working all this time, but all of a sudden i am getting this error:
"[OLE DB Source ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER . The AcquireConnection method call to the connection manager "AccessDB_CONN" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed."
i created a test SSIS package through the import/export wizard and it worked, but the next time i tried this test package got the same error as the one above. i have txt files that load to SSIS packages to the same server, these are working fine.
It looks like the error has something to do with Ms Access connection. someone help me.
the funny thing is if i try to execute any step in VS Dev studio (i have about 70 steps that load 70 different tables. i just combined all these steps into one package). so if i execute any single step in the dev server i get that error. if i execute the entire package from the filename.dtxs file it executes, but extremely slow. so my concern is not able to run in Dev server yet i can run by clicking the filename.dtxs file