SSIS
(Integration services) is the most powerful ETL tool for data management and
analysis included with SQL server Enterprise edition and Standard suit. All
though we have many data ware housing tools available in the market (oracle,
cognos, sap, informatica, talend, Teradata etc.). Microsoft business intelligence
providing efficient tools for managing data and generating reports (SSRS) and
for analysis of business data (SSAS). Let me start integrations services first.
Firstly you need to know about ETL term.

ETL
Stands for

1.Extraction

2.Transformation

3.Loading

Data sources: - As shown in above SQL Server /flat files/third-party apps. Assume a supermarket had hundreds of
stores across the state. All the stores sales information stores in central
database or else individuals databases. So each super market assumed as source
for the data. Here the main task is loading data from the different types of
sources to the destination as shown above block diagram. The business owner
want to see how much sales has been done per a day or month, year. For this kind
of scenario we need to use ETL tools let us go through topic extraction,
transformation, loading

Extraction: - extracting
data from any type of source.

Transformation:
- Changing the data or transforming the data as per the user requirement.

Loading: - Loading
the data into database for analysis purpose. And maintaining historical data in
data ware house

Most Of the transformations
uses SQL query as input command so SSIS is highly dependent on SQL Server