• Article

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 Integration Services package to run and configure the connection to the storage location.

To learn about this task, see Execute Package Task.

For information about how to pass values from the parent package to the child package, see How to: Use the Values of Parent Variables in a Child Package.

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 Considerations for Installing Integration Services.

Location Dynamic Options

Location = SQL Server

  • Connection
    Select an OLE DB connection manager in the list, or click <New connection...> to create a new connection manager.

    Related Topics:OLE DB Connection Manager, Configure OLE DB Connection Manager

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

Location = File system