O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Connections

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required