I am trying to pull information down from an Oracle database.

Running a basic select statement in a ExecuteSQL task runs fine, but adding
a TransformData task from Oracle to SQL hangs.

I can add the connection to Oracle
I can add the transform data task line
But when double-clicking on the Transform Data Task line to get to the
properties, EM hangs.

I am connecting via ODBC to Oracle.

Any help much appreciateed.
BM

Does it really hang or does it just take along time? How many tables do you
have in Oracle and SQL Server? If there are a lot of tables, then this can
take along time since this is not a very efficient process. Try another DB
with less tables for a test.


--
Darren Green
http://www.sqldts.com

"Beema" <none (AT) supplied (DOT) com> wrote

I let it go on for about 15-20 mins before kllling the process.

You may be right about the number of tables, there's 50 squillion tables in
the Oracle db.

Will let it go a little longer & see. Thanks for the info.



"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Maybe you could take a structure only copy of the tables into an empty DB,
and build your package against that. Then change the connection and data
pump destination object (which uses the three part name) to change back to
the correct DB. Should be quicker for development, and avoid enumerating the
real DBs tables.


--
Darren Green
http://www.sqldts.com


"Beema" <none (AT) supplied (DOT) com> wrote