Copy SQL Server Objects Task (Destination Tab)

DTS Designer

DTS Designer Help

Copy SQL Server Objects Task (Destination Tab)

Use this tab to specify the destination to which the data is to be copied and to provide the appropriate security context through which users can access the database.

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 Microsoft Windows® 98 computers.

See Also

Copy SQL Server Objects Task