Thursday, March 31, 2011

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

Guys,


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

Sudhir


 

  


 

 

 

No comments: