Thursday, March 31, 2011

What is SSIS? Step 1 of the Stairway to Integration Services


As we know that SQL Server Integration Services is one of the most popular subsystems in SQL Server. In allows us to Extract, Transform, and Load (ETL) data between a variety of data sources and programmatically change data in any manner you can think of and script in C#.

We can use SSIS to:
  • Perform ETL (Extract, Transform, and Load) operations
  • Transfer data
  • Copy database objects
  • Perform FTP operations
  • Work with files
This article from SQLServerCentral provides an introduction to SQL Server Integration Services, and an overview of its architecture.

To read this article, click here

Happy learning







No comments: