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.
Configuration of 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 of this component, see Set the Properties of a Data Flow Component.