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.