SQL Server Compact Edition Destination

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

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

This destination uses an SQL Server 2005 Compact Edition 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 2005 Compact Edition 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 2005 Compact Edition 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:

• Common Properties
• Destination Custom Properties

For more information about how to set properties, click one of the following topics:

• How to: Set the Properties of a Data Flow Component in the Properties Window
• How to: Set the Properties of a Data Flow Component Using the Advanced Editor

See Also

Concepts

Creating Package Data Flow

Other Resources

Integration Services Destinations

Help and Information

Getting SQL Server 2005 Assistance

Change History