Hello everyone!
I am having problems executing a DTS package from a StoredProcedure. This DTS Package consists of two steps. The first one delete a table in SqlServer to prepare for 2nd step. The 2nd step reads data from an Oracle server and insert data into the previous table. When I run this package from within the Data Transaformation Services section it works. when i try to run it from SQLAnalyzer using a stored procedure I get the following error.

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0

Error Detail Records:

Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0

DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
NULL


I am running this from the box where this is going to run. ALso, I have installed all the Oracle client software and ODBC driver in this box. I have created DSN connections using the Oracle driver and tested it, and it connects.
any suggestiion on how to solve the issue happening here will be appreciated it. thanks in advance....