I have a need of dynamically creating a brand new, empty Microsoft Access database to temporarily house some data coming in from various Excel spreadsheets.
I've looked extensively online this afternoon and haven't found out how to do this aside from some vague mentions of needing to implement code within a Script Task Transformation in SSIS.
Anyone out there accomplished this and willing to share a snippet of the code you used to do this?
Many thanks in advance.