SSIS & SSRS

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software which can be used to perform a broad range of data migration tasks.
SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.


Integration Services includes

• graphical tools and wizards for building and debugging packages;
• tasks for performing workflow functions such as FTP operations, SQL statement execution, and e-mail messaging;
• data sources and destinations for extracting and loading data;
• transformations for cleaning, aggregating, merging, and copying data;
• a management service, the Integration Services service, for administering Integration Services packages;
• and application programming interfaces (APIs) for programming the Integration Services object model.

Typical Uses of Integration Services

• Merging Data from Heterogeneous Data Stores
• Populating Data Warehouses and Data Marts
• Cleaning and Standardizing Data
• Building Business Intelligence into a Data Transformation Process
• Automating Administrative Functions and Data Loading

SSRS - SQL Server Reporting Services

SSRS provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality.