The data flow in a sql server 2005 integration services ssis package is constructed by using different types of data flow elements : sources that extract data , transformations that modify and aggregate data , destinations that load data , and paths that connect the outputs and inputs of data flow components into a data flow Sql server 2005 integration services ( ssis )包中的数据流用下列不同类型的数据流元素构造而成:提取数据的源、修改和聚合数据的转换、加载数据的目标以及将数据流组件的输出和输入连接为数据流的路径。
Hence , it is obvious that the importance of data warehouse and data mart . presently , the researches on data warehouse are mainly focused on how to extract , load , clean , compute , aggregate data and how to improve storage structure in data warehouse . but , the management of data warehouse process self is little noted 目前,对数据仓库的研究大多集中于如何对数据进行抽取、装载、清洗、计算、聚合等过程上,以及如何改善数据仓库的物理存储结构,提高存储空间的利用效率上,而对数据仓库自身的管理则很少引起人们的注意。