Can SSIS output an SQL Server Compact 4.0 file?

2
votes

I am using SSIS 2008 to read data from my database. Now I would like it to save that data in an SQL Server Compact 4.0 file (which will be read by the ASP.net MVC 3 app)

Has anyone else done this?

Like I said this is for a SQL CE 4.0, not 3.5

2
ssissql-server-cesql-server-ce-4

2 Answers

0
votes

Use the SQL Server Compact Destination component in a data flow.

0
votes

you have a component specially to do this:

enter image description here