ssis ssrs mysql,使用SSRS，SSAS，SSIS的优点

Hello Sir,

I want to ask the benefits of using SSRS , SSAS ,SSIS and SSMS .Please guide me

SS(RS+AS+IS+MS) what''s the need of it

解决方案All four are very different things not related to each other beyond being related to SQL Service; only first tree are "Services". If you don''t see where is the need in each, maybe you don''t need them? :-) To find it out, see:

http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services[^],

http://en.wikipedia.org/wiki/Microsoft_Analysis_Services[^],

http://en.wikipedia.org/wiki/SQL_Server_Integration_Services[^],

http://en.wikipedia.org/wiki/SQL_Server_Management_Studio[^].

—SA

These are called components of BI (Microsoft SQL Server Business Intelligence)

Like wise called as MS BI.

SSIS : SQL Server Integration Services : This service / tool is used to create ETL / packages as per business requirement and to load data mostly use for Data warehouse data migration process.

SSRS : SQL Server reporting Services : This service / tool is used to create reports as per business requirement

SSAS : SQL Server Analysis Services : Advance vesion of reporting . This is used to crated Adhoc report . Used to create cube which we can use in reporting to enable user to generate adhoc report as per there requirement

SSMS/SSME : actually it is SSME Sql Server Management environment where you can interact with sql server to do your developement , administration activities.

This all combined made for Datawarehouse.