Export (0) Print
Expand All
Expand Minimize

Execute Package Task Editor (Package Page)

Updated: 5 December 2005

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.

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

Release History

5 December 2005

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

Community Additions

ADD
Show:
© 2014 Microsoft