I'm trying to import data from 10 Oracle databases into a single MS SQL DB. I thought I could use the Loop Connections together with Import Wizard.
My issue is that when I put the import task inside the loop and I tick the 'use connection from automation ' and 'from parent', it looks like Toad is thinking I want to import to the Oracle database that is in the loop.
But I swear I have done this and it worked in previous version. I'm using version 126.96.36.1995
Any idea how I can make this work?