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
 
Transferring data using SQL Server Integration Services
Note 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.
Note 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 may 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
See also
Working with versions
Exporting UNICOM Intelligence data to Quantum
Exporting UNICOM Intelligence data to IBM SPSS Statistics
Transferring UNICOM Intelligence data to a different location
Importing data from XML and exporting to IBM SPSS Statistics
SSIS packages
Copying a UNICOM Intelligence database to another location
Importing data into Microsoft Excel
SSIS troubleshooting
Filtering data in SQL Server Integration Services
Related topics about advanced transfers
Creating a relational MR database from a Quanvert database
Creating a relational MR database from an IBM SPSS Statistics.sav file
Exporting data from XML to a relational MR database
See also
Accessing case data from third party applications