I am new to DTS. I have created a package containing several steps
using Oracle as the source db. The database contains several
instances of the same schema with different owners. A sample of a
source query follows:

SELECT HA.DEFENDANT.UID, HA.DEFENDANT.SEQUENCE,
HA.ORGANIZATION.NAME,
'A' AS EXPR1
FROM HA.DEFENDANT,
HA.ORGANIZATION
WHERE HA.DEFENDANT.UID_LOF
= HA.ORGANIZATION.UID

The different owners are HA, HB ...

How can I set up this package to be reused for each instance. Thanks.

In message <d20e2d6f.0404231237.6afb7767 (AT) posting (DOT) google.com>, Mike S
<mike.schiewer (AT) ssfhs (DOT) org> writes
Why not remove the owners from the SQL, and just change the login used
by the connection to the correct owner.

If you really want to play with the SQL, then you will probably need to
use a Script Task, something like this-
Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org