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

Tuesday Oct 9th 2007 by DatabaseJournal.com Staff
Share:

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.

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved