Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS and sql Mobile

Author  Topic 

johnyBravo
Starting Member

1 Post

Posted - 2008-04-04 : 10:55:23
There might be many ways to do this, but Id like to hear your suggestions. This is what I need to do

Copy tables from a regular sql server (2000) and write them into a *.sdf file. This file needs to be then transferred to a hand held device that runs on windows mobile 5 operating system.

Now I know I can copy tables from a sql server to *.sdf using SSIS. But how do I create the sdf in he first place? SSIS doesn't create a sdf file. It just writes to a sdf file. Also whats the best way of transferring the sdf file to a hand held device? I read some where about using active sync and remote API for a situation like this. But I am not sure how this is done. Any help is greatly appreciated.
   

- Advertisement -