Post reply

DTS SQL Server -> SQL Server technology used question

  • February 20, 2004 at 4:11 am

    #101886

    Hi,

    Can anyone tell me what technologies (ADO, ODBC, whatever) SQL server uses when you use a DTS to export data from 1 SQL Server to another.

    Thx

  • February 20, 2004 at 7:28 am

    #494919

    The default data access technology when moving from one SQL Server to another is OLE-DB for SQL Server.  When you create a connection object in DTS the drop down for "Data Source" is defaulted to  "Microsoft OLE DB provider for SQL Server"

    Diane

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply