Job fails..But DTS Works

Hi All,
I have a DTS Package which transforms data from a SQL
Server table to Oracle using ODBC (Oracle 9.1.2). If I
run the DTS, it works OK. If I Schedule the DTS as a job,
I'am getting error:
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
OS : Win200
Login : Administrator
SQL : 2000
Login :sa
Please help !!!!
Thanks in Advance,
SKHave a look at the following :-
http://support.microsoft.com/?kbid=269074
--
HTH
Ryan Waight, MCDBA, MCSE
"SK" <skumar@.nycboe.net> wrote in message
news:04fe01c38f38$cb1cf900$a001280a@.phx.gbl...
> Hi All,
> I have a DTS Package which transforms data from a SQL
> Server table to Oracle using ODBC (Oracle 9.1.2). If I
> run the DTS, it works OK. If I Schedule the DTS as a job,
> I'am getting error:
> 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
> OS : Win200
> Login : Administrator
> SQL : 2000
> Login :sa
> Please help !!!!
> Thanks in Advance,
> SK
>|||I have recreated the DTS and Job as per the security
mentioned in the article (same username with full
control), but still the same error !!!!!
>--Original Message--
>Have a look at the following :-
>http://support.microsoft.com/?kbid=269074
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"SK" <skumar@.nycboe.net> wrote in message
>news:04fe01c38f38$cb1cf900$a001280a@.phx.gbl...
>> Hi All,
>> I have a DTS Package which transforms data from a SQL
>> Server table to Oracle using ODBC (Oracle 9.1.2). If I
>> run the DTS, it works OK. If I Schedule the DTS as a
job,
>> I'am getting error:
>> 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
>> OS : Win200
>> Login : Administrator
>> SQL : 2000
>> Login :sa
>> Please help !!!!
>> Thanks in Advance,
>> SK
>
>.
>