Difference between SSIS Vs SSAS

SSAS is SQL Server Analysis Services used to Build Cubes and Dimensional Database Model ..SSIS is Sql Server Integration Service which is used to automate SQL Server tasks whatever it is related to SSAS, T-SQL and other regular ETL tasks

SSIS - SQL SEVER INTEGRATION SERVIce
data manipulation,data transfomation and much more
SSAS - SQL SERVER Analysis Service
analysis of data

SSIS:

1. It is just two dimensional data comprising of rows and columns
2. We can apply DML changes.
3. We can maintain only current data (upto 3 months records of bank statements).
4. If data is huge it is damn slow.


SSAS:

1. It is multidimensional data comprising of cube.
2. Only select the data.
3. We can maintain historical data. (above 3 months).
4. It is quite fast because of use of mdx.


Thanks & Best Regards,
Durga.

SSIS : basically it use for the collection of data from the different database and convert into one common for example : migrate of data from flat file into sql server 2008 ... and its is basced on the ETL ( Extraction Transformation Load ) Concept

E: Extract the data from the database
T:Transform the data or process the data
L:Load The data



SSAS: Sql server analysis services as its name implies it is for the analysis of the data and it is used to Build cubes and database dimensional models and that data is view in the reportiong services......

- Use SSIS to (a) move data from production and (b) flatten it into the warehousing schema (a snowflake/constellation schema)

- Use SSAS to build cubes on top of the data warehouse