I am running some DTS tasks against an Oracle database
and have some questions. I can establish my connection
alight via OLE DB. When I query the Oracle database do I
need to write the queries in T-SQL or PL/SQL? We are
converting from SQL Server to Oracle and I have the
queries going against the same database in SQL Server and
then I try to run them against the Oracle instance and I
am having problems. Any help is appreciated.

When you query the connection to the Oracle database, you
have to use PL/SQL. Although id still T-SQL, the syntax is
slightly different, for instance the functions (like TOP)
and LEFT JOIN, etc.

If your SQL Server queries use that syntax, you may need
to re-write the statements to get the same results.