Hi Everyone

I have a DTS package which runs fine from the Enterprise manager but
the job fails. I am logged into the server as the sysadmin and the job
owner is the sa account. I have also made sure that all have full
rights to the SQL database. The DTS job has a bunch of SQL Tasks and
few OLAP tasks. Whenever the job encounters an OLAP task, it gives me
the error 'Object variable not set' and errors out.

Any help is appreciated

Ujval

OK so on the server, who is the SQL Server Agent service account as this is the account with which the package will try to run.
You mentioned it works using EM.

Acually on the server itself?

Try logging in as the SQL Server Agent service account on the server nd run the DTS package through EM.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


<ujval.gandhi (AT) gmail (DOT) com> wrote