A new task

Recently I was given a little task about extracting data from a SQL Server 2005 to a Microsoft Access database. The objective was to drop an Access file on a shared filesystem location within the company.

I chose to work with the SQL Server Integration Services (SSIS), which was built for such tasks. You can find some general info about SSIS on the Microsoft SSIS homepage.

SQL Server integration Services is an available option when you’re installing SQL Server 2005 (Standard, Developer or Enterprise Edition).

continue reading…