# How to import to MSSQL from multiple Oracle databases

**URL:** <https://forums.toadworld.com/t/how-to-import-to-mssql-from-multiple-oracle-databases/50249>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [July 2, 2020, 5:42pm UTC](https://forums.toadworld.com/t/how-to-import-to-mssql-from-multiple-oracle-databases/50249 "2020-07-02T17:42:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cesar.zapata](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@cesar.zapata](https://forums.toadworld.com/u/cesar.zapata)\
**Post date:** [July 2, 2020, 5:42pm UTC](https://forums.toadworld.com/t/how-to-import-to-mssql-from-multiple-oracle-databases/50249/1 "2020-07-02T17:42:52Z")

</div>

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 5.1.7.425

Any idea how I can make this work?

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [July 2, 2020, 11:09pm UTC](https://forums.toadworld.com/t/how-to-import-to-mssql-from-multiple-oracle-databases/50249/2 "2020-07-02T23:09:52Z")

</div>

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