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
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