Hi,

I have a DTS job which consists of around 34 Cubes. Scheduled to run daily
at 1 am. Some times the job is getting failed. When I look at the error log,
I can see this message "CONNECTION TO THE SERVER IS LOST". But if i open the
DTS and open the particular cube, it is not showing the connection prob. And
the same job is successfully executing next day with out any issues.

Please advice me, Why it is happening. I have checked memory and hd space,
both are quite good too...

Thanks for any help regarding this.

Thanks and regards
Sajith

Does this article help?

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


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