摘要
DTS组件是SQL Server提供的实现数据抽取和转换的工具,基于DTS组件,通过ODBC连接多种数据源,能够实现数据的自动抽取,并且提出了该方法的实现原理和部分基于C#的实现代码。
The data transformation services (DTS) within the SQL server provide the graphical tools and the COM object used to extract, transform and consolidate the data from the different sources. The automatic implementation of the data extraction by the ODBC connecting the multiple data sources is introduced by an analysis of the DTS.
出处
《成都信息工程学院学报》
2006年第5期679-682,共4页
Journal of Chengdu University of Information Technology