2

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

vcsjones
  • 138,677
  • 31
  • 291
  • 286
Joe
  • 286
  • 1
  • 2
  • 13

2 Answers2

0

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

Jeroen Bolle
  • 1,836
  • 1
  • 12
  • 15
0

you have a component specially to do this:

enter image description here

Diego
  • 34,802
  • 21
  • 91
  • 134