SSIS and SQL CE

eXavier

2009-05-22 09:21:01 UTC

Hello,
finally I found out why my post was ignored even I have valid MSDN
subscription. After renewal of MSDN Subscription it is required to create new
alias email address - I wonder why I cannot just associate my existing one
and why it is not associated automatically. But it is probably topic for
different forum.

Post by eXavier
Hello,
I need to import some tables to SQL Compact Edition file (.sdf). I've
created new SSIS package but when I'm trying to create Connection Manager to
SQL CE, there is error in provider - instead of properties there is only
message "Object reference not set to an instance of an object." displayed in
the dialog.
I have installed SQL CE 3.5 SP1. The SSIS project is created in VS2005 (I
ADO.NET -> .NetProviders\Microsoft SQL Server Compact Data Provider.
<add name="Microsoft SQL Server Compact Data Provider"
invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data
Provider for Microsoft SQL Server Compact"
type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe,
Version=3.5.0.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>
and I check the referenced assembly is also in GAC.
What could be wrong? How could I import the tables (and data) into sdf file?
Thanks
eXavier