AnsweredAssumed Answered

SSIS ODBC Error Connectiong to FM16 Table

Question asked by dmannon@vectorusa.com on Mar 25, 2018
Latest reply on Mar 28, 2018 by tcfitzgerald

I am trying to connect to FileMaker 16 Bonsai database from SQL Server 2012 using ODBC connection and SSIS ODBC Source.  I have set up FileMaker ODBC Data Source and successfully tested connection.  In SQL Server Data Tools using ODBC Source in Data Flow I am able to connect to FileMaker.  ODBC Source is able to see number of tables in Bonsai database including the "CUSTOMER" table.  When attempting to preview data to map columns I get error "Error at Data Flow Task [ODBC Source [2]]: There was an error while trying to get schema information. Table has no columns".  Can anyone advise me how to extract data from Bonsai customer table?  Seems whatever table/view option I select in SSIS I get same "Table has no columns" message.  Any help / advice would be greatly appreciated.

Outcomes