SSIS与SSAS之间的区别 [英] Difference between SSIS Vs SSAS

问题描述

SSIS和SSAS有什么区别？他们在SSIS和SSAS之间是否有任何关系？

What is the difference between SSIS and SSAS? Is their any relation between SSIS and SSAS?

推荐答案

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2dceb8ab-9d1f-4fe9-9e8e-cb0f4999a6ba [ ^ ]

SSAS是用于构建多维数据集和维度数据库模型的SQL Server Analysis Services .SSIS是Sql Server集成服务，用于自动执行任何相关的SQL Server任务到SSAS，T-SQL和其他常规ETL任务

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

数据操作，数据转换等等

SSAS - SQL SERVER分析服务

数据分析

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

这篇关于SSIS与SSAS之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！