Copy SQL Server Objects Task (Source Tab)

DTS Designer

DTS Designer Help

Copy SQL Server Objects Task (Source Tab)

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.

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