I created an SSIS package that creates 6 local cube files using the create
global cube statement. The cubes work fine if I run the SSIS package on my
PC or if I run the package on the server and it is just overwriting the cubes
I already created from running the package on my PC. However, if I just run
the package on the server with no existing local cube files, when I try to
access via Excel 2003, a dialog box pops up asking me for the data source and
it has the path of the cube in it. Nothing I key in here lets me into the
cube.

My theory is that Excel has to be present on the machine where the local
cubes are first created. If it is, the DSN is set and any overwrites keep
working. Is this true - do I need to load Excel on the server?

On further research, I have found my SSIS package works correctly on two 32
bit servers and does not work correctly on one 64 bit server. I am not sure
if the MSXML6.0 64 bit software, PTSLite.exe, or some other required software
for local cubes is incompatible or if I am still missing a required piece of
software. Any suggestions would be appreciated.

"bhorwatt" wrote: