| title | SQL Server Compact Edition Destination | |||
|---|---|---|---|---|
| description | SQL Server Compact Edition Destination | |||
| author | chugugrace | |||
| ms.author | chugu | |||
| ms.date | 03/14/2017 | |||
| ms.service | sql | |||
| ms.subservice | integration-services | |||
| ms.topic | how-to | |||
| f1_keywords |
|
|||
| helpviewer_keywords |
|
[!INCLUDEsqlserver-ssis]
The [!INCLUDEssNoVersion] Compact destination writes data to [!INCLUDEssNoVersion] Compact databases.
Note
On a 64-bit computer, you must run packages that connect to [!INCLUDEssNoVersion] Compact data sources in 32-bit mode. The [!INCLUDEssNoVersion] Compact provider that [!INCLUDEssISnoversion] uses to connect to [!INCLUDEssNoVersion] Compact data sources is available only in a 32-bit version. SQL Server Compact destination is not supported from VS2022. Details refer to Microsoft SQL Server Compact Lifecycle.
You configure the [!INCLUDEssNoVersion] Compact destination by specifying the name of the table into which the [!INCLUDEssNoVersion] Compact destination inserts the data. The custom property TableName of the [!INCLUDEssNoVersion] Compact destination contains the table name.
This destination uses an [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] Compact destination has one input and does not support an error output.
You can set properties through [!INCLUDEssIS] 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.