Share via

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