Hi PB_BI,

Thanks so much for the in depth response. It may take a while for me to digest as I'm not exactly an expert when it comes to...

Hi PB_BI,

Thanks for responding.  Are you referring to the "Drillthrough" or the "Drillthrough and Local Cube" permission for the Local Cube/Drillthrough Access property of the cube?

It seems at...

Hi Steve,

"It looks to me like you've simply set the condition for the path to the next task after the Analysis services Dimension to operate on failure instead...

The Failure workflow attaches from the OLAP task to an Expression task which both reside in the For Loop.   Please see the image below. 
Just to reiterate, all I'm wondering...

Ok, thanks Steve.  I will give that a try.  But I had thought Tim indicated that I was to set the Fail Parent for the OLAP Task only if the Error/Failure workflow attaches...

Hi Tim,

Thanks for the reply. The Error/Failure workflow attaches from the OLAP task to an Expression task and both of these tasks are within the For Loop container....

OK, thanks for the information Steve. I was sensing that the message box was causing the problem.  Note that this package won't be running in a SQL Agent job though. Instead,...

Ok, thanks Steve. I implemented your suggestion.  One thing I neglected to mention is that I have a Script task in the OnError event which displays a messagebox containing ErrorDescription value.  This...

Thanks for the information. I will make a note of it.

"It could be a DNS issue. Try to use the IP address and port of the source OLTP server...

Ok, thank you for replying. I may look into your suggestion. There is a sporadic communication problem I'm running into where an OLAP server cannot establish a connection...

On a related note, I figured I would add an OnError Event Handler to each of the tasks in my packages. Each of these handlers will have a script task...

Thanks for the info. I looked into adding an Event Handler to the package and I think that is the route I'm going to take (I'm relatively new to SSIS...

Thanks for the response. Yes, I can modify the packages. Your suggestion sounds good. In connection to it, something else I was working on that seems to work is...

Thanks for the response. As I recall though, I don't believe there were any messages listed as warnings either. I will keep that in mind though for the future...