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
- Open the Execute Package Task Editor.
- The Options on the General Page.
- Set the Options on the Package Page.
- Options on the Parameter Bindings Page.
1. Open the Execute Package Task Editor
- Open Integration Services project in Visual Studio. that contains an Execute Package task.
- 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.