SQL Server Compact Edition Destination

The SQL Server Compact destination writes data to SQL Server Compact databases.


On a 64-bit computer, you must run packages that connect to SQL Server Compact data sources in 32-bit mode. The SQL Server Compact provider that Integration Services uses to connect to SQL Server Compact data sources is available only in a 32-bit version.

You configure the SQL Server Compact destination by specifying the name of the table into which the SQL Server Compact destination inserts the data. The custom property TableName of the SQL Server Compact destination contains the table name.

This destination uses an SQL Server Compact connection manager to connect to a data source, and the connection manager specifies the OLE DB provider to use. For more information, see SQL Server Compact Edition Connection Manager.

The SQL Server Compact destination includes the TableName custom property, which can be updated by a property expression when the package is loaded. For more information, see Integration Services Expression Reference, Using Property Expressions in Packages, and Destination Custom Properties.

The SQL Server Compact destination has one input and does not support an error output.

Configuring the SQL Server Compact Edition Destination

You can set properties through SSIS Designer or programmatically.

The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:

For more information about how to set properties, see How to: Set the Properties of a Data Flow Component.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.