I duplicated Chapter 5 in my database to automatically import text files from a folder on our network and everything works great.
When I tried to change that package to import data from a bunch of Access Databases I'm running into a problem with feeding the connection manager the name of the Access Databases dynamically.
After I add the Expression ("Data Source=" + @[User::sFileName] + ";Provider=Microsoft.Jet.OLEDB.4.0;")
to the connection manager to get the ConnectionString from the variable, I get an error on the OLE DB source editor that says "The AcquireConnection method call to the connection manager "ACCESS_DATABASE" failed with error 0XC0202009"
Any idea what I'm missing?