We need some help figuring out how to run scheduled jobs (dts packages) without using the SQLSERVERAGENT as the user who runs the package. We cannot use the agent because of security reasons beyond our control. There has to be other simple ways to run this package.
The DTS Package looks like this
Truncate --> OLE DB Provider for Oracle --> QA --> Load Table.
Hopefully that makes sense to someone because I'm a new to the database world.