Chapter 3. Connections
Microsoft SQL server provides several connections for data transformation services right out of the box. DTS is able to use ODBC drivers and OLE DB providers to connect to database management systems, file system databases, applications, and text files. The following is the list of built-in connections that come with SQL Server 2000:
Microsoft OLE DB Provider for SQL Server
Microsoft ODBC Driver for Oracle
Microsoft OLE DB Provider for DB2 (see the sidebar “DB2 Connection”)
Microsoft Access
dBase 5
Paradox 5.x
Microsoft Excel 97–2000
Text File (Source)
Text File (Destination)
HTML File (Source)
Microsoft Data Link
Other Connection
DB2 ...
Get SQL Server DTS now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.