Connect to SQL Server Compact Edition in SSIS

Posted by user218795 on Stack Overflow See other posts from Stack Overflow or by user218795
Published on 2010-03-25T15:49:48Z Indexed on 2010/03/25 15:53 UTC
Read the original article Hit count: 500

Filed under:
|
|

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 provider (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.

© Stack Overflow or respective owner

Related posts about ssis

Related posts about ADO.NET