Friday, September 2, 2016

INTRODUCTION TO SSIS

Sql Server Integration Services (SSIS) is ETL (Extract, Transform, Load) Tool, developed by Microsoft to perform ETL operations; i.e. Extract, Transform, and consolidate data from different sources and load it to a single or multiple destinations. It provides a platform to build data integration and workflow applications. SSIS packages can be created using BIDS (Business Intelligence Development Studio).
Business Intelligence Development Studio is the environment that we will use to develop packages for data extraction, transformation, and loading (ETL) in Integration Services. Business Intelligence Development Studio is the Visual Studio 2008 environment with enhancements that are specific to business intelligence solutions. Business Intelligence Development Studio (BIDS) will be available as client tool when installing SQL Server Management Studio (SSMS).
Usage of SSIS:
    Populate data warehouses.
  • Manage, Clean and Standardize data.
  • Merge data from multiple data sources, either from relational data bases or from flat files etc.
  • Automating database administrative tasks.

1 comment:

  1. A big thank you Reddy Sir for providing such a excellent post and information on SSIS basics.I just like to know that will it be possible for you to publish a post on SSIS Upsert.I need to understand it as soon as possible.Thanks.

    ReplyDelete