Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for
building high performance data integration solutions, including the
extraction, transformation, and loading (ETL) of packages for data
warehousing. SSIS is the new name assigned to the component formerly
branded as Data Transformation Services (DTS).
SSIS (SQL Server Integration Services) is an upgrade of DTS (DataTransformation Services), which is a feature of the previous version ofSQL Server. SSIS packages can be created in BIDS (Business IntelligenceDevelopment Studio). These can be used to merge data from heterogeneousdata sources into SQL Server. They can also be used to populate datawarehouses, to clean and standardize data, and to automateadministrative tasks.
For More insight look into this document http://
It creates and manages Web-enabled reporting services. It is used to
create and generate reports, to retrieve data from various data sources,
and to publish reports in various formats.
SQL Server Reporting Services 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.
With Reporting Services, you can create interactive, tabular, graphical,
or free-form reports from relational, multidimensional, or XML-based
data sources. You can publish reports, schedule report processing, or
access reports on-demand. Reporting Services also enables you to create
ad hoc reports based on predefined models, and to interactively explore
data within the model. You can select from a variety of viewing formats,
export reports to other applications, and subscribe to published
reports. The reports that you create can be viewed over a Web-based
connection or as part of a Microsoft Windows application or SharePoint
site. Reporting Services provides the key to your business data.
SQL Server Analysis Services (SSAS) enables BI (Business Intelligence)
workers to work on multi-dimensional data in SQL Server which can be gathered
from different kinds of resources like flat files to relational databases.
SSAS (SQL Server Analysis Services) has the ability
to analyze data grouped and aggregated into different formats and views like the
faces of a cube.
A SSAS application adds the value of data analysis and represents the data in the format of OLAP cubes
, OLAP reporting
or data mining