Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > Accessing case data from third party applications > Transferring data using SQL Server Integration Services > Filtering data in SQL Server Integration Services > Editing the SSIS package
 
Editing the SSIS package
1 Open SQL Server Management Studio, and select the Server on which the SSIS package you want to edit is stored.
2 Expand the Data Transformation Services folder, so that you can see the SSIS packages.
3 Double-click the SSIS package you want to edit.
4 Double-click the line connecting Connection 1 and Connection 2.
This opens the Transform Data Task Properties dialog box.
5 Select the Transformations tab.
The left pane shows the variables you selected for export and the right pane shows all of the variables in the data set.
6 Select all of the variables in the left pane.
7 Scroll through the list of variables in the right pane, selecting all of the variables that you selected for export.
8 Click Delete all.
9 Refresh the display by selecting another tab and then selecting the Transformations tab again.
You should now see lines connecting each variable in the left pane with its corresponding variable in the right pane.
10 Scroll through the list checking that each variable in the left pane is connected to the correct variable in the right pane. If necessary, repeat the last four steps, until you are successful.
11 Click OK.
12 You can now save the package and run it.
For information about Quantum DSC error and warning messages, see Quantum DSC error and warning messages.
Requirements
UNICOM Intelligence Data Model
Microsoft SQL Server
See also
SSIS troubleshooting
Filtering data in SQL Server Integration Services
Exporting UNICOM Intelligence data to Quantum
Quantum DSC
Transferring data using SQL Server Integration Services