Consider the following rules and guidelines when you configure an ODBC source:
ODBC source connections do not detect primary-foreign-key relationships. Therefore, these tables do not appear related when you add multiple source objects.
If you add multiple MySQL tables as the source for a task and you use an ODBC connection to connect to MySQL, you must use a user-defined join. If you create the relationship and run the task, the task fails.
You cannot use the
select * from <table_name>
command in a saved query. You must provide the explicit column list.