August 8, 2016 at 8:52 am
Greetings! I am working on a project for my company, where our customers will be receiving SDF (SQLCE v3.5) files from remote users, and will need to (easily) import the data from those into their SQL Server (typically, Server/Express 2008 & 2012). Exactly which version of SQL Server (Express/Standard/etc.; 2008/2012) will vary by customer. Due to these and other environmental differences from one customer to the next, I fully expect to write an import process specific to each customer, and am fine with that.
I've been searching for ways to do this with VS2013 Pro by creating an SSIS Import package, but cannot seem to fine a way to have the .sdf file as a "Source" in the "Data Flow Task".
I am also open to the possibility of a .sql script which can run from command line.
There will be about 3 tables on the .sdf file which need to be extracted, based on a simple where clause (e.g., WHERE ColumnName = 1), but if need be, I can do all of this in SQL Server post-import/processing.
Any help would be appreciated. I did do some searching through the forums here, and did not find anything truly applicable (some export form SQL Server to SQL CE, but that's not what I'm trying to do).
If this topic would be better placed somewhere else, please let me know.
Thanks in advance
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply