dbTalk Databases Forums  

Multiple OLAP related DTS packages

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


Discuss Multiple OLAP related DTS packages in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Canadean
 
Posts: n/a

Default Multiple OLAP related DTS packages - 07-10-2006 , 09:27 AM






Hi all,
I have a problem...

I have two DTS packages that run fine, each one contains several steps all
related to build shared dimensions and cubes on the analysis server.

Each package works fine on it's own.

I created another DTS package which simply calls the other two packages. It
has two step, one for each package.

If I run each step of the calling package individually, it works fine,
however, if if hit the run button (even from design mode) to execute all the
steps, the package hangs. There is a workflow connection between the two
steps that is set to 'on success'

To recreate this do the following.
In analysis manager, create a simple shared dimension and a simple cube that
uses that dimension (this relationship may not be relevant but this was my
test model)
Create a DTS package to rebuild the shared dimension, call it BuildDIM
Create a DTS package to rebuild the cube, call it BuildCUBE
Create a DTS package that runs BuidlDIM and BuildCube with a workflow
connection set to 'on success', call it BuildBoth
From BuildBoth's design view, execute the first step manually, when it's
completed execute the second step, both should complete without errors.
Now click the run icon to execute both steps.
The DTS package should now fail.

If anyone has any ides please let me know.

Thanks in advance.

Al.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.