Toad World® Forums

How to import to MSSQL from multiple Oracle databases

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

Any idea how I can make this work?

Are you using the Import/Export wizard to do this inside the loop? You may need to share your automation workflow.