Thanks to Greg Robidoux and Jeremy Kadlec, I have now published my first MSSqlTips Tip.
Dynamically build connection objects for Microsoft Access databases in SQL Server Integration Services