> [OLE DB Source [113]] Error: SSIS Error Code
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "msAccess" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. .
I am new in SSIS Packages designing for learning purpose I am Designing dtsx packages. i have a .mdb file that I am trying to import in my sql server 2016 . when I design packages it running successfully but when I deploy that packages and try to run that packages through package utility it showing me above error. i searched a lot i changed my packages properties like delay validation= true and validate external metadata = false. But after deploying packages data is not loading into my respective table.
The most likely answer is that you don't have the .mdb file in the same local folder on the SQL Server:
C:\Users\Administrator\Desktop\msAccess.mdb
When you deploy the package and run it through the package utility, the package is running ON the SQL Server, and not on your local box anymore. So any local path in the package will be interpreted as a local path on the SQL Server.
sorry for late reply. I gave SQL server agent permission access to my packages and they are running through my stored procedure and also my mdb file i gave access to SQL server agent to access that file –
User contributions licensed under CC BY-SA 3.0