Types of MSBI Execute Package Task Editor

Execute Package Task Editor

The Task Editor configure the Execute Package Task. The capabilities of Integration Services packages run other packages.

Types of MSBI Execute Package Task Editor

  1.   Open the Execute Package Task Editor.
  2.  The Options on the General Page.
  3.   Set the Options on the Package Page.
  4.   Options on the Parameter Bindings Page.

1. Open the Execute Package Task Editor

  1.   Open Integration Services project in Visual Studio. that contains an Execute Package task.  
  2. The task in the SSIS Designer and Edit.

2. Set the Options on the General Page

Name  Provide a unique name for the Execute Package task. This name used as the label in the task icon. Description  Type a description of the Execute Package task.

3. Set the Options on the Package Page

ReferenceType  Select Project Reference for child packages that are in the project. Select External Reference for child packages located outside the package  

Password   If the child package is password protected. It provides the password for the child package. click the ellipsis button (…) and create a new password for the child package.

ExecuteOutOfProcess   the child package runs the parent package or in a separate process. the ExecuteOutOfProcess property of the Execute Package task is set to False. the child package runs in the same process as the parent package. If set this property to true, the child package runs in a separate process. The slow down child package property value is true. The debug package can't install the Integration Services product.

ReferenceType Dynamic Options Execute Package Task Editor

ReferenceType = External Reference Location  Select the location of the child package. This property has the options listed in the following table.   Value Description SQL Server Set the location to an instance of SQL Server. File system Set the location to the file system. Connection  Select the type of storage location for the child package. Package Name Read Only  Displays the package name. ReferenceType = Project Reference

PackageNameFromProjectReference

 Select a package contained in the project, to be the child package. Location Dynamic Options Location = SQL Server Connection  Select an OLE DB connection manager in the list. The click create a new connection manager. PackageName  Type the name of the child package. click the ellipsis then locate the package. Location = File system Connection  Select a File connection manager in the list. The click to create a new connection manager. Package Name Read Only  Displays the package name.

4. The Options Parameter Bindings Page

The pass values from parent package or project child package. The project must use the project deployment model. the child package contained in the same project that contains the parent package. The converting projects to the project deployment model. Deploy Integration Services (SSIS) Projects and Packages. Child package parameter  Enter or select a name for the child package parameter. Binding parameter or variable  Select the parameter or variable that contains the value that you want to pass to the child package. Add  Click to map parameter or variable child package parameter. Remove  Click to remove a mapping parameter or variable and a child package parameter.

Types of MSBI Execute Package Task Editor

Types of MSBI Execute Package Task Editor: We is the best MSBI training institute in Hyderabad. It offers Types of MSBI Execute Package Task Editor.