Show TOC

Procedure documentationAdding and Modifying Packages Locate this document in the navigation structure

 

After creating a package in SQL Server Business Intelligence Development Studio, you must add it to the Data Manager.

You can also take that package and modify it within Data Manager. You can modify packages through SSIS (as described below) or you can modify packages using custom tasks using the MODIFYSCRIPT package variable. The MODIFYSCRIPT package variable allows you to set up predefined answers to package prompts so that you can automate running packages. See MODIFYSCRIPT Package Variable Task Usage.

Prerequisites

You have created a package using SQL Server Business Intelligence Development Studio, and you have appropriate task security to add or modify packages. See the Planning and Consolidation Security Guide for more information.

Procedure

To add a package to Data Manager:

  1. Choose   eData   Organize Package List  

  2. Select a team and package group and click Add Package.

  3. Enter data as required. See Package Properties.

  4. Save your changes.

To modify a package:

  1. From the application server, start Microsoft SQL Server Business Intelligence Developer Studio.

  2. In the context menu of the Microsoft SSIS folder, click Open Package.

  3. In the target application set and application, choose \\DataManager\PackageFiles\Examples\.

  4. Select a sample package.

  5. In the Select Package dialog box, select the package you want to modify and click OK.

  6. Open the task to modify and view its properties. See Custom Tasks.