My environment is: Windows 2008 server SQL Server 2008 SSIS 2008 (SQL Server Business Intelligence Development Studio V9) Filemaker 11 ODBC I have a data flow transform with an ADO NET source (connection to Filemaker via ODBC). Using the ADO.NET source editor, if I select a table and then click on Preview, the query results show the data plus the column names, ie All looks good. However, as soon as I click on Columns (still using the ADO.NET Source Editor), the available columns list is empty. It seems like it is not retrieving the metadata. Hence, I am stuck and I cannot complete the transform. I've tried things like using a "select * ..." rather than selecting a table, or just selecting one field. Makes no difference. Note that if I use Excel to retrieve the data, it all works fine. The issue seems peculiar to using SSIS. Also note that I don't have any issues with other data sources and that this worked ok when I was accessing Filemaker 8 using an earlier driver from DataDirect. The Filemaker 11 ODBC driver is supplied directly by Filemaker. DataDirect do not support Filemaker 11. This has been posted on a Filemaker forum with no resolution - Filemaker feel that driver is ok. It has also been posted on Experts Exchange with no resolution - except that it confirms it's probably a metadata related issue. So, is this an SSIS or Filemaker issue? Is anyone using SSIS with Filemaker 11 successfully? Any further ideas? Cheers, John

I think you need another driver, maybe this driver can't fetch metadata based on what SSIS expects. or as a workaround you can use this way: use an execute sql task and select * from yourtable from FileMaker database . then set result set as full, and fill result in an object type variable, then you can read this object type variable within a data flow task with script component as source. This was a workaround not a solution, but may help you to pass this step till data provider problem solve.http://www.rad.pasfu.com

Thanks for the workaround idea.