Using DTS: Import From/Export To a Non-Microsoft Database

DTS, an integral part of MS SQL 2000 server, moves data very easily between MS SQL Servers and between Microsoft products. However, it can also reliably move data to and from non-Microsoft databases. Although DTS requires a Microsoft license, it can be implemented independently of MS SQL 2000 Server. This step-by-step, how-to tutorial describes the process of moving data between MS SQL 2000 Server and Sybase's SQL Anywhere server. The key interface required for this is either a OLEDB or a ODBC compliant driver. Although the DTS designer is a better tool than the Import/Export wizard, we will be using the wizard.


Read the full article here: Using DTS: Import From/Export To a Non-Microsoft Database

For more discussion go here: Blog Article Discussion