filemaker to SQL server using DTS?

[Zeina]

Hi everyone,

I need to export data from filemaker on to SQl server 2000. I was hoping on using SQl's DTS tool, is that possible? Has anyone ever created a DTS using filemaker db as a source? if so please HELP!

thanks

Zeina

[Zeina]

It works beautifully.

I was able to create an ODBC connection (filemaker) and with the dts export some fields (with transafortions if required) to an excel spreadsheet which can then be emailed to clients.

The problem was that filemaker db needs to be opened prior to executing the DTS job....now I am looking into a way of opening the filemaker file on the fly....from possibly SQL DTS?