|
Joydeep
|
Posted: Friday 09, May 2008 12:09:58 PM
|
|
|
help
|
|
Back to Top
^ |
|
| Coder | Posted: Friday 09, May 2008 12:15:21 PM | | DTS - Data Transfer Service
It is used to transfer data between two data source in SQL
Server. which supports OLEDB. You can use DTS to import and
export data from one source to other source.
- Coder
| | Back to Top ^ | | |
| Sachin Walunj | Posted: Sunday 15, February 2009 05:13:53 AM | | DTS stands for Data Transformation Services, It is a set of obj
ects and utilities to allow the automation of extract, transfor
m and load (ETL) operations to or from a database. For extract\
loading it support hetrogeneous system from third party datbase
management systems, text files, xml files, web services etc.
It was first introduced with Microsoft SQL Server 2000 and it w
as renamed ast SSIS (SQL Server Integration Services) with the
release of SQL Server 2005, with the latest release of SQL Serv
er 2008, it has become one of the powerful tool for ETL. It is
a key component of the Microsoft Business Intelligence Stack...
| | Back to Top ^ | | |
|