Export (0) Print
Expand All
Expand Minimize

Copy SQL Server Objects Task (Destination Tab)

SQL Server 2000

  New Information - SQL Server 2000 SP3.

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.

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

See Also

Copy SQL Server Objects Task

Show:
© 2014 Microsoft