I am experiencing an SQL 2014 Job Package that is not connecting to MS Access when the package is either scheduled or manually running it. The package connects and runs fine when I developed it in VBS with no errors. The package dtsx was deployed to SSIS in the Integration Services Catalog SSISB.
Connection String value: Data Source=\\xxxx\xxxx\xxxx\Da
Server Name: \\xxxx\xxxx\xxxx\Databases
Password: [left blank as there is no mdw and the mdb is not password protected]
These are the Connections available through the Connection Manager, once I select the OLEDB, then I selected the Microsoft Jet 4.0 OLE DB Provider. It tests and connects with VBS, just not in the SSIS Server Agent Jobs.