Re: DTS package runs fine but Job fails
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 02/19/05
- Next message: Allan Mitchell: "Re: Package fails "Cannot use a CONTAINS or FREETEXT predicate""
- Previous message: Allan Mitchell: "Re: Execute Package Task and setting its inner Package Global Vaiables"
- In reply to: ujval.gandhi_at_gmail.com: "DTS package runs fine but Job fails"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 19 Feb 2005 17:30:49 -0000
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@gmail.com> wrote in message news:1108739428.895910.324790@o13g2000cwo.googlegroups.com... > 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 >
- Next message: Allan Mitchell: "Re: Package fails "Cannot use a CONTAINS or FREETEXT predicate""
- Previous message: Allan Mitchell: "Re: Execute Package Task and setting its inner Package Global Vaiables"
- In reply to: ujval.gandhi_at_gmail.com: "DTS package runs fine but Job fails"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
