Hi - just to add to Phil's post - extracting data from Filemaker is pretty slow. I currently use SSIS to do a few data extracts from Filemaker (directly - I set up ODBC on the server and set up the appropriate Filemaker permissions) and the extraction is probably the slowest part of the process. I also found that some of the normal SQL constructs that I'm used to using aren't supported in Filemaker, so I grab everything I need from it, put it in a staging table, and then do my manipulation/selection from there.
HTH,
Doc Tree