How to import an Excel file into SQL Server 2005 using Integration Services

October 9, 2007

[From TechRepublic]

Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a wonderful tool for extracting, transforming, and loading data. Common uses for Integration Services include: loading data into the database; changing data into to or out from your relational database structures; loading your data warehouse data; and taking data out of your database and moving it to other databases or types of storage. This article describes how you can use the new features of SQL Server 2005 Integration Services (SSIS) to load an Excel file into your database.

The article continues at http://blogs.techrepublic.com.com/datacenter/?p=205