Using Integration Services with SQL Server Compact Edition
New: 14 April 2006
Microsoft SQL Server Compact Edition is the compact database that enables you to extend enterprise data management and business intelligence capabilities to mobile devices. By using the Microsoft SQL Server 2005 Integration Services components designed specifically for SQL Server 2005 Compact Edition, you can create Integration Services packages that write data to SQL Server 2005 Compact Edition databases, and you can embed access to SQL Server 2005 Compact Edition databases in applications.
This topic focuses on the Integration Services objects that are especially designed to work with SQL Server 2005 Compact Edition. Integration Services also includes a wealth of objects to connect to SQL Server 2005 databases. You can extract and write data, execute SQL statements, and perform administrative database tasks. For more information, see Using Integration Services with the Database Engine.
Connection Managers
A connection manager is a logical representation of a connection to a data source. When a package runs, the Integration Services runtime creates a physical connection using the attributes of the connection manager. Integration Services provides a variety of connection managers that tasks and data flow components can use to connect to databases and other types of data stores. For example, the Execute SQL task connects to a relational database to run SQL statements; the OLE DB source and destination extract data from and load data into databases; and the Lookup transformations access lookup tables stored in a database. However, only the SQL Server 2005 Compact Edition connection manager is specifically designed to work with SQL Server 2005 Compact Edition databases.
SQL Server Compact Edition Connection Manager
A SQL Server 2005 Compact Edition connection manager enables a package to connect to a SQL Server 2005 Compact Edition database. The SQL Server 2005 Compact Edition destination in SQL Server 2005 Integration Services (SSIS) uses this connection manager to load data into a table in a SQL Server 2005 Compact Edition database.
For more information, see SQL Server Compact Edition Connection Manager.
Data Flow Destinations
Destinations are the data flow components that load the output of a data flow into different types of data sources, or create an in-memory dataset. Only the SQL Server 2005 Compact Edition destination is specific to SQL Server Compact Edition.
SQL Server Compact Edition Destination
The SQL Server 2005 Compact Edition destination loads data into a SQL Server 2005 Compact Edition database. You configure the SQL Server 2005 Compact Edition destination by specifying the name of the table into which the SQL SQL Server 2005 Compact Edition destination inserts the data.
For more information about this destination, see SQL Server Compact Edition Destination.
See Also
Concepts
Using Integration Services with the Database Engine
Using Integration Services with Analysis Services
Using Integration Services with Data Mining
Using Integration Services with Other Applications
Other Resources
Using Integration Services with Other SQL Server Features