Transferring data using SQL Server Integration Services

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

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

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

This section describes how to use SQL Server Integration Services and the UNICOM Intelligence Data Model to transfer case data, for example, from one format to another, or from one location to another. This section also covers using the UNICOM Intelligence Data Model to import data into Microsoft Excel.

If you have UNICOM Intelligence Professional, you can use a DataManagementScript (DMS) file to transfer data from one format or location to another, along with other data management tasks, such as cleaning the data, setting up weighting variables, defining filters, and so on. For more information, see Data Management overview.

Warning: In Microsoft SQL Server, DTS has been replaced by SQL Server Integration Services (SSIS). You might be able to migrate any existing DTS packages that you have to SSIS. This section does not describe the use of SSIS. For more information about SSIS, see the SQL Server documentation.

The UNICOM Intelligence Data Model uses components, called data source components (DSCs), to read and write data in different formats. For an information about the DSCs that are supplied with the UNICOM Intelligence Data Model, see Available DSCs.

The DSC Registration component automatically enumerates all of the DSCs that are registered on your system. This means that when you connect to the UNICOM Intelligence Data Model in SQL Server, you can read case data from any format for which you have a suitable read-enabled CDSC and you can write to any data format for which you have a suitable write-enabled CDSC. For example:

▪You can use the Relational MR Database (RDB) DSC to read UNICOM Intelligence Interviewer data that is stored in a relational MR database, and you can use to write the data to a .sav file for analysis in IBM SPSS Statistics, or you can use Quantum DSC to write the data to a .dat file for analysis in Quantum.

▪When you need to send the data to another location, you can use the UNICOM Intelligence Data File CDSC to write the data to a file, which you can then send to another site, for example, by email. The recipient can then use SQL Server Integration Services to transfer the data to the required format.

You can use the SQL Server Integration Services Import/Export wizard to transfer data between the different formats. You can also save all of the settings of a data transformation by setting up a SQL Server Integration Services package that you can run again and again.

Requirements

▪UNICOM Intelligence Data Model

▪Microsoft SQL Server