FM Server 11 and odbc on SQL 2005

[itsisnofun]

We currently pull data from FMP-A back to some sql tables to be merged with other data from other sources using obdc. Currently using server 9 advanced and just upgraded clients to ver 11 of FMP-A. On testing the new odbc drivere that is requirerd for ver 11 of FMP-S the DSN sets up and test okay and I can place my select statement in the connector inside the SSIS package but the fields from the select statement do not return in the connector under column mapper. Also I notice just testing using excel and the DNS that the odbc driver is now case sentative on it return data. If my select statement pull from a field that have states in it and it should = 'ga' it pulls just 'ga' and not 'GA' or 'Ga'.

Is anyoine using the new odbc driver to pull data back to a sql table using SSIS package on SQL 2005?

Mike