Well you can export the FM data into a csv, xml, tab, dbf, etc then import into your SQL db.
I am not sure why you are using a ESS shadow table strictly for an import. Another option would be to write a loop that sets the shadow fields to the values in your FM table.
Next another option would be to install the ODBC driver for FileMaker if you have it and use SQL to import via ODBC.
Yet another option would be to look into: http://www.fmpromigrator.com/products/fmpro_migrator/index.html
I want to avoid exporting a file from FM as this has turned out to be extremely problematic.
My client, who is running FM Pro, wants the ability to push data from his FM database to a MS SQL table I've set up at his leisure.
Is this not possible to do natively from FM Pro?
I'd rather not have my client spend more money on yet another tool (like FM Pro Migrator) to accomplish this.
Like I said, you could write a script that takes the data in your FileMaker files and puts them into variables, then goes to the layout of your shadow table and sets the values and commits the record.
There are some pitfalls as FileMaker is a LOT more lenient in data types than traditional dbs.