Execute Package Task Editor (Package Page)
TOC
Collapse the table of content
Expand the table of content

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.

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 = 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

Connection

Select a File connection manager in the list, or click <New connection...> to create a new connection manager.

Related Topics:File Connection Manager, File Connection Manager Editor

PackageNameReadOnly

Displays the package name.

Community Additions

ADD
Show:
© 2016 Microsoft