| 基于SSIS企业数据集成系统的技术实现 |
| |
| 引用本文： | 苏鹏,李钊,王文,刘学理. 基于SSIS企业数据集成系统的技术实现[J]. 计算机应用与软件, 2008, 25(9) |
| |
| 作者姓名： | 苏鹏 李钊 王文 刘学理 |
| |
| 作者单位： | 1. 山东建筑大学管理学院,山东,济南,250101
2. 山东省计算中心,山东,济南,250014 |
| |
| 摘 要： | 论述了一个基于SSIS(Microsoft SQL Server 2005 Integration Services)的企业数据集成系统的技术实现.该系统采用自顶向下的策略实现,其任务执行、并发控制与日志功能均以SSIS为基础,可以对包括远程和本地关系型数据库、文本文件、Excel表格等各种企业异构数据源中的业务数据进行统计计算并将统计结果通过Web Services发布到外部系统.
|
| 关 键 词： | 数据集成 集成系统 |
IMPLEMENTATION OF TECHNIQUES FOR ENTERPRISE DATA INTEGRATION SYSTEM BASED ON SSIS |
| |
| Su Peng,Li Zhao,Wang Wen,Liu Xueli. IMPLEMENTATION OF TECHNIQUES FOR ENTERPRISE DATA INTEGRATION SYSTEM BASED ON SSIS[J]. Computer Applications and Software, 2008, 25(9) |
| |
| Authors: | Su Peng Li Zhao Wang Wen Liu Xueli |
| |
| Affiliation: | Su Peng1 Li Zhao2 Wang Wen1 Liu Xueli11(School of Management,Sh,ong University of Architeture,Jinan 250101,Sh,ong,China)2(Sh,ong Computer Science Center,Jinan 250014,China) |
| |
| Abstract: | In this paper it demonstrates the Implementation of Techniques for enterprise data integrated system based on SSIS (Microsoft SOL Server 2005 Integration Services). This system adopts top-down approach to implement with its task execution,concurrent control and logging function all based on SSIS,it can make statistics and compute values of the data from enterprise heterogeneous data sources including remote and local relational database,text,Excel sheet,etc. and publish the statistical results to external s... |
| |
| Keywords: | SSIS |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
