摘要
论述了一个基于SSIS(Microsoft SQL Server 2005 Integration Services)的企业数据集成系统的技术实现。该系统采用自顶向下的策略实现,其任务执行、并发控制与日志功能均以SSIS为基础,可以对包括远程和本地关系型数据库、文本文件、Excel表格等各种企业异构数据源中的业务数据进行统计计算并将统计结果通过Web Services发布到外部系统。
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 statistJical results to external systems through Web Services.
出处
《计算机应用与软件》
CSCD
北大核心
2008年第9期179-180,202,共3页
Computer Applications and Software