Export (0) Print
Expand All
Expand Minimize

Copy SQL Server Objects Task (Source Tab)

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Use this tab to select the source of the data to be copied and to provide the appropriate security context through which users can access the database.

Options

Description

Specify an optional description of the Copy SQL Server Objects task. This text becomes the name of the Copy SQL Server Objects task icon on the Data Transformation Services (DTS) Designer design sheet.

Server

Specify the name of the server containing the data source.

Use Windows Authentication

Specify that the package use Windows Authentication for login to the Microsoft® SQL Server™ database.

Use SQL Server Authentication

Specify that the package use SQL Server Authentication for login to the SQL Server database.

Security Note  When possible, use Windows Authentication.

User name

Specify a user name for the database connection.

Password

Specify a password for the database connection.

Database

List databases on the specified server.

Refresh

Cause the database list to populate on computers running Microsoft Windows® 98.

See Also

Copy SQL Server Objects Task

TransferObjectsTask Object

Show:
© 2014 Microsoft