Sorry Steve...

I was just telling the questions, I was asked. But I am really not having answer for the first and third question.

1. Difference between OLEDB and OLAP....May be I was tricked like you said...:-)

2. for the 3rd question he asked me "there are two containers contains two SQL tasks. One container is set to option required and other one to supported. When one task in each container fails, whether other task would roll back or not?"

I told "both will roll back"

and he siad "If both of them rolled back, then what is the difference between setting options to required and supported? "

Steve, Could you please clarify me ?