I don't know if anyone has any experience in this, but I want to bulk load data from <some db> to SQL Server 2005 Mobile Edition. I did find a utility that does this (free but will time-out) and want to be able to do loads at some time in the future.

I thought to try MySQL's SQL dump file, sorta-kinda works, but not for bulk inserts.

I thought to use SSIS and, although a .NET ADO Mobile Edition provider is available, SSIS is having trouble playing nice.

Any ideas??

TIA