Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     

5 important SSIS, SSRS and SSAS(MSBI) interview questions

Explain Web service task in SSIS?

Web Service task let us execute web services.
  • First we configure HTTP Connection manager which will point to WSDL of a web service. 
  • Web service task uses this HTTP Connection manager and let us invoke methods in it.
  • Return values of method value we can store it in some variables and can use as input for some other tasks.

Can you explain transfer SQL Server object task?

It allows us to transfer different SQL server objects between different instances of SQL Server.
Object means table, stored procedures, user defined functions etc.

In SSIS is it possible to communicate with MSMQ?

Yes, for that we have Message Queue task. It let us send messages to MSMQ and receive message from MSMQ.

What’s the advantage of using MSMQ?

MSMQ let two applications communicate with each other asynchronously. Specialty is two application may be built using different technology and it works even offline messaging. Sender will store messages inside queue and reader reads it wherever required. 

Say something about mail sending and executing custom logic in SSIS?

For sending mail we have send mail tasks.  First we configure the task for SMTP and other settings and then send mail.

On the other hand SSIS have a task called Script task which will let us write custom C# or code and opens many doors for us.

For BI Step by Step series click here.

For technical trainings on various topics like WCF, MVC, Business Intelligence, Design Patterns, WPF, TFS and Basic fundamentals feel free to contact or visit

For more stuff like this, click here. Subscribe to article updates or follow at twitter @SukeshMarla

Also see another SSIS, SSAS and SSRS(MSBI) interview questions video on basics of SSIS , SSAS and SSRS: -

Helpful Website Url
Share this article   |    Print    |    Article read by 29932 times
Shivprasad koirala Koirala
I am a Microsoft MVP for ASP/ASP.NET and currently a CEO of a small E-learning company in India. We are very much active in making training videos , writing books and corporate trainings. Do visit my site for .NET, C# , design pattern , WCF , Silverlight , LINQ , ASP.NET , ADO.NET , Sharepoint , UML , SQL Server training and Interview questions and answers
Related Articles:
Related Interview Questions: