Hi. Please see error below we're getting when executing
a package. This has worked in the past. The only
changes have been the addition of some cubes and shared
dimensions to the datamart. Oh, and a the latest MS
Security Patch applied: SP4.

Some things to note:
1. AS2K (Win2K Server) with the cubes/dimensions is on a
separate box than SQL2K (Win2K Server) from where package
resides.
2. We have mirrored AS2K and SQL2K servers that are not
having this problem.

Thanks,

Walter Miller
millerw3 (AT) wellsfargo (DOT) com [3 to e to respond]


Error = 1 (00000001), Description = 8/3/2003 7:08:05
AM 12841 Committing transaction in
Database 'ACDataMart'
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Analysis Server Error: Connection
to the server is lost; Time:8/3/2003 7:08:10 AM
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Error(-2147221411): Process
operation failed; Time:8/3/2003 7:08:10 AM
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Error(-2147221423): Unable to open
server object (Internal (Database 'ACDataMart' could not
be opened on the server)); Time:8/3/2003 7:08:10 AM
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Rolling back transaction in
Database 'ACDataMart'
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Analysis Server Error: Connection
to the server is lost; Time:8/3/2003 7:08:10 AM

-----End Task Log-----


Step 'DTSStep_DTSOlapProcess.Task_2' was not executed