A cross connection query can be used in an import template.
If the import template with cross connection query was created before and then it's being selected in automation, Toad gives a validation error that states the connection is wrong.
However, the import template runs successfully.
WORKAROUND:
Create the import template directly in the automation, using the wizard.
STATUS:
Waiting for fix in a future release of Toad Data Point
