Package as a Job

#1

I have a package that executes just fine when i select 'execute'
When i go to schedule it, the corresponding job is created. But when i run
the job, it fails. It says: "Cannot connect to the Analysis server on
computer 'ENG1SQLV1'. Connection to the server is lost Error source:
DSO"

is this an issue with the job component of sqlserveragent?

The package simply makes a server connection, runs a sp to extract/build a
table, runs an analysis services full process on a cube. The package, the sp
and analysis services are all on the same database server though sql server
is clustered.

any ideas would be helpful. thx.

#2

This article invariably helps when a package runs interactively but not as a
job.

http://support.microsoft.com/?kbid=269074

"TroyS" <troy.stauber (AT) ilg (DOT) com> wrote

Quote:

I have a package that executes just fine when i select 'execute'
When i go to schedule it, the corresponding job is created. But when i run
the job, it fails. It says: "Cannot connect to the Analysis server on
computer 'ENG1SQLV1'. Connection to the server is lost Error
source: DSO"

is this an issue with the job component of sqlserveragent?

The package simply makes a server connection, runs a sp to extract/build a
table, runs an analysis services full process on a cube. The package, the
sp and analysis services are all on the same database server though sql
server is clustered.

any ideas would be helpful. thx.

#3

Thx. I went thru the article to troubleshoot and still have the same issue
where the job fails, but the package executes.
I'll keep poking around...

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

This article invariably helps when a package runs interactively but not as
a job.

http://support.microsoft.com/?kbid=269074

"TroyS" <troy.stauber (AT) ilg (DOT) com> wrote in message
news:eUfItwmqFHA.2604 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
I have a package that executes just fine when i select 'execute'
When i go to schedule it, the corresponding job is created. But when i
run the job, it fails. It says: "Cannot connect to the Analysis server
on computer 'ENG1SQLV1'. Connection to the server is lost Error
source: DSO"

is this an issue with the job component of sqlserveragent?

The package simply makes a server connection, runs a sp to extract/build
a table, runs an analysis services full process on a cube. The package,
the sp and analysis services are all on the same database server though
sql server is clustered.

any ideas would be helpful. thx.

#4

Hi,
I'm currently experiencing the same issue that you have just desribed. I
would really appreciate it if you could point me in the right direction.
Have checked OLAP administrators, etc.
Thanks a lot!

"TroyS" wrote:

Quote:

I have a package that executes just fine when i select 'execute'
When i go to schedule it, the corresponding job is created. But when i run
the job, it fails. It says: "Cannot connect to the Analysis server on
computer 'ENG1SQLV1'. Connection to the server is lost Error source:
DSO"

is this an issue with the job component of sqlserveragent?

The package simply makes a server connection, runs a sp to extract/build a
table, runs an analysis services full process on a cube. The package, the sp
and analysis services are all on the same database server though sql server
is clustered.

any ideas would be helpful. thx.

#5

Usually when things like this happen it can be explained with this
article

http://support.microsoft.com/?kbid=269074

Allan

"PS" <PS (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,
I'm currently experiencing the same issue that you have just desribed.
I
would really appreciate it if you could point me in the right direction.
Have checked OLAP administrators, etc.
Thanks a lot!

"TroyS" wrote:

I have a package that executes just fine when i select 'execute'
When i go to schedule it, the corresponding job is created. But when i
run
the job, it fails. It says: "Cannot connect to the Analysis server on
computer 'ENG1SQLV1'. Connection to the server is lost Error
source:
DSO"

is this an issue with the job component of sqlserveragent?

The package simply makes a server connection, runs a sp to
extract/build a
table, runs an analysis services full process on a cube. The package,
the sp
and analysis services are all on the same database server though sql
server
is clustered.

any ideas would be helpful. thx.

#6

So far I am absolutely sure it is an issue when rebuild dimensions or process cubes is called inside a DTS.

Anyone has a work around?

From http://www.developmentnow.com/g/103_...e-as-a-Job.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Package as a Job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Package as a Job - 08-26-2005 , 01:30 PM

Re: Package as a Job - 08-27-2005 , 02:11 AM

Re: Package as a Job - 08-31-2005 , 08:52 AM

RE: Package as a Job - 11-07-2005 , 08:01 AM

RE: Package as a Job - 11-07-2005 , 01:10 PM

RE: Package as a Job - 08-06-2007 , 08:59 PM