Skip to content

Latest commit

 

History

History
49 lines (34 loc) · 3.79 KB

sql-server-compact-edition-destination.md

File metadata and controls

49 lines (34 loc) · 3.79 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords
SQL Server Compact Edition Destination
SQL Server Compact Edition Destination
chugugrace
chugu
03/14/2017
sql
integration-services
how-to
sql13.dts.designer.sqlservercompactdest.f1
destinations [Integration Services], SQL Server Compact
SQL Server Compact, destination
inserting data

SQL Server Compact Edition Destination

[!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.

Configuration of the SQL Server Compact Edition Destination

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:

Related Tasks

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

See Also

Data Flow