Copy Database Wizard (Configure the Package)

The Copy Database Wizard creates a SSIS package to transfer the database. Use this page to customize the package.

Options

• Package location
  Displays the Object Explorer node where the SSIS package will be written.

• Package name
  Enter a name for the SSIS package. The default package name is CDW_<source server>_<destination server>_#. The character # is an incremental integer that is used if the package name already exists on the destination server.

• Logging options
  Select whether to store the logging information in the Windows event log or in a text file.

• Save transfer logs?
  Select to create one or more files that contain scripting details that might be useful for analyzing the Transact-SQL generated to perform the transfer. The files are saved on the destination server to <Documents and Settings>\<user name>\Local Settings\Application Data\Microsoft\SQL Server\Smo\TransferDumpNNN.sql, where NNN is a random number.

• Error log file path
  Select to provide a local file path on the destination server. This option is available only if Logging options is selected. To use the Select the folder for package log dialog box, click the ellipsis button (...).