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.
Select the location type. This property has the options listed in the following table.
Set the location to an instance of SQL Server. Selecting this value displays the dynamic options, Connection and PackageName.
Set the location to the file system. Selecting this value displays the dynamic option, Connection.
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.
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
Select an OLE DB connection manager in the list, or click <New connection...> to create a new connection manager.
Type the name of the child package, or click the ellipsis (…) and then locate the package.