This topic has not yet been rated - Rate this topic

Choose Source Location (DTS Package Migration Wizard)

SQL Server 2008 R2

Use the Choose Source Location page to specify the source from which to migrate packages.

Source

Select the type of storage to search for packages to migrate.

Value	Description
Microsoft SQL Server	Migrate packages from an existing instance of SQL Server. Selecting this value displays the dynamic options in the Source (SQL Server) table.
Structured Storage File	Migrate packages stored as a structured storage file. Selecting this value displays the dynamic options in the Source (Structured Storage File) table.

Server name: Type a server name or select a server in the list.
Use Windows authentication: Select to use Windows Authentication to connect to the server.
Use SQL Server authentication: Select to use SQL Server Authentication to connect to the server.
User name: If using SQL Server Authentication, specify a user name.
Password: If using SQL Server Authentication, provide a password.

File name: Type the name of a structured storage file or click Browse and locate the file.
Browse: Browse to locate the structured storage file.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions