SSIS: How to create and export data to Microsoft Access 2003 database?
- by Sung Meister
Goals
- Automate exporting SQL Server 2005 views to Microsoft Access 2003 database (no transformation required) through SQL Server Job (with SSIS package)
There is no "Access DB Destination" in BI toolbox.
So the question is,
How can I create an Access database (for me to load data to)?