Import Wizard Query

Import Wizard Query

When using the Import Data Wizard in SQL Server, part of the process
allows me to enter a query to import data from the source server and
database.  Does this query execute on the destination computer or the
source computer?  

In my situation, I use the Import Wizard from a local instance of SQL
Server connecting to a Oracle database located in another state,
different from the destination.  My query does work and extracts the
data from the Oracle database located in another state and returns the
result set to my local instance of SQL Server, into the destination
database and respective table.  

Questions:

1. Does this query window act in a similar manner as a pass-through
query does in Access?

2. Does the query entered into the query window on my SQL Server
Import Data Wizard execute on the destination computer or passed to
the source Oracle database server? 

SQL Server 2005, SP2 
Oracle DB located in IL
SQL Server located in OH

date: Thu, 04 Sep 2008 21:20:22 -0400 author: Tim Ponds NoEmailPlease@Thankyou

RE: Import Wizard Query

Hi Tim,

The query is executed on the source server and then results are pulled from 
there to your destination computer. If you want you can save the generated 
SSIS package (check the option at the end of the wizard) and take a look at 
what it is doing exactly. 

RubÃ©n GarrigÃ³s
Solid Quality Mentors

"Tim Ponds" wrote:

> When using the Import Data Wizard in SQL Server, part of the process
> allows me to enter a query to import data from the source server and
> database.  Does this query execute on the destination computer or the
> source computer?  
> 
> In my situation, I use the Import Wizard from a local instance of SQL
> Server connecting to a Oracle database located in another state,
> different from the destination.  My query does work and extracts the
> data from the Oracle database located in another state and returns the
> result set to my local instance of SQL Server, into the destination
> database and respective table.  
> 
> Questions:
> 
> 1. Does this query window act in a similar manner as a pass-through
> query does in Access?
> 
> 2. Does the query entered into the query window on my SQL Server
> Import Data Wizard execute on the destination computer or passed to
> the source Oracle database server? 
> 
> SQL Server 2005, SP2 
> Oracle DB located in IL
> SQL Server located in OH
>