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