SSIS packages

Developer Documentation Library > 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 > SSIS packages

SSIS packages

For information on working with the SQL Server Import and Export Wizard, see:

http://technet.microsoft.com/en-us/library/ms141209(SQL.90).aspx

After you have created a SSIS package using the SQL Server option, you can view it in the SQL Server Management Studio window: expanding the Data Transformation Services folder, and then double-click Local Packages. All of the SSIS packages on the selected server are then displayed in the pane on the right.

When you double-click a SSIS package in SQL Server Management Studio, it is opened in the SSIS Designer window.

You can edit the SSIS package in the, by double-clicking the objects. For example, when you double-click one of the connection objects, the Connection dialog opens. When you click Properties in this dialog, the Data Link Properties dialog opens and you can change the options.

Requirements

UNICOM Intelligence Data Model

Microsoft SQL Server