Execute Package Task Editor (Package Page)

Use the Package page of the Execute Package Task Editor dialog box to specify the location of the SQL Server 2005 Integration Services (SSIS) package to run and configure the connection to the storage location.

To learn about this task, see Execute Package Task.

Static Options

  • Location
    Select the location type. This property has the options listed in the following table.

    Value Description

    SQL Server

    Set the location to an instance of SQL Server. Selecting this value displays the dynamic options, Connection and PackageName.

    File system

    Set the location to the file system. Selecting this value displays the dynamic option, Connection.

  • Password
    If the child package is password protected, provide the password for the child package, or click the ellipsis button (…) and create a new password for the child package.
  • ExecuteOutOfProcess
    Specify whether child package runs in the process of the parent package or in a separate process. true if the child package should run in a separate process, false if the child package should run in the same process. If set to false, you cannot debug the package in a tools-only install; you must install the Integration Services product. For more information, see Installing SQL Server Integration Services by Using Setup.

Location Dynamic Options

Location = SQL Server

  • PackageName
    Type the name of the child package, or click the ellipsis (…) and then locate the package.

Location = File system

  • PackageNameReadOnly
    Displays the package name.

See Also

Reference

Execute Package Task Editor (General Page)
Expressions Page

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

5 December 2005

New content:
  • Added information about consequences of running child packages in a separate process.