It is impossible to say what goes wrong, since we do not have the database here. But - there should be no problem whatsoever loading several tables using one single connection.
I would delete the script and generate it from scratch again - without renaming anything. Aim for something like the following:
ODBC CONNECT TO DataSummary;
SQL Select * From im_reporting_zone.dbo.Analysis_J_Test;
SQL Select * From im_reporting_zone.dbo.Analysis_J_FleetSizebyMonthEnd;
That is, as simple as possible. Just two tables and just 100 records from each. Then you can look for errors or synthetic keys, or other fields that needs to be renamed.