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
have also VS2008 installed on the same machine). The provider used is:
ADO.NET -> .NetProviders\Microsoft SQL Server Compact Data Provider.

It is registered in machine.config as:
<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

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.

But the question still remains unanwered: