I was trying to figure out how to get some data from an ODBC source and put it into SQL, and found a post with an interesting possible answer:
Recently, I discovered an issue with SQL Server Integration Services (SSIS) regarding how the Execute SQL Task item handles returning a result set to the control flow. Lets start by demonstrating an existing issue with the Execute SQL Task using ODBC then I’ll present a solution. First, create a new DSN that points to the database using the ODBC Data Sources Administrator (Control Panel | Administrator Tools | ODBC Data Sources). If you are only dealing with SQL Server you can still test this out by creating a DSN that uses the SQL Server ODBC driver.
Sql Server Integration Service (SSIS) Execute SQL Task ODBC Result Set Bug/Workaround