September 27, 200421 yr 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
September 29, 200421 yr Author 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?
Create an account or sign in to comment