SQL Server Compact Edition Destination
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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 (SSIS) Expressions, Use Property Expressions in Packages, and SQL Server Compact Edition Destination Custom Properties.
The SQL Server Compact destination has one input and does not support an error output.
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 of this component, see Set the Properties of a Data Flow Component.