开发者

Connect to SQL Server Compact Edition in SSIS

开发者 https://www.devze.com 2022-12-24 12:02 出处：网络

Till now I\'ve been exporting data INTO the SQL Server CE database, but now in SSIS I\'m attempting to source data that was inserted in a previous step of the import.

相关专题：ado.net sql-server-ce ssis

Till now I've been exporting data INTO the SQL Server CE database, but now in SSIS I'm attempting to source data that was inserted in a previous step of the import.

The SSIS fails during validation with the following error

Error: Microsoft.SqlServer.Dts.Runtime.DtsCouldNotCreateManagedConnectionException: Could not create a managed connection manager.

I am attempting to use the ADO NET Source that connects to the Data Source using the Microsoft.SqlServerCe.Client.3.5 pro开发者_运维技巧vider (i.e. ADO.NET connection manager). I CAN preview the data in the ADO.NET Source editor, but the package validation fails due to the above error.

Using SQL Compact as a source is not supported in SSIS. You must use other tools...