How cai tranform data from an existing SQL server 2005 DB to a (.sdf) SQL server Compact Edition DB ?
I don't know the data provider name for connecting to a SQL CE DB..
ANy suggestions ?
You can use the SQL Server Compact Edition Destination component (with a File Connection Manager) in a Data Flow Task to "export" data to SQL Server Mobile. You can place some transformations between your data source and the destination component.
