Tag Archives: MSBI

MSBI Interview Question’s:- Part 1

We have come up with few real-time questions asked to one of the fresher candidate during MSBI(SSIS, SSAS and SSRS) interview questions if you are one of those who is seeking for the same then below questions and answers will surely … Continue reading

Posted in MSBI, MSBI Interview Question, Uncategorized | Tagged , , , , , | Leave a comment

How to perform Script Task and send email using Script Task?

Script Tasks are used to send an email or do any web related tasks where customization is required. In Script Task for doing the customization we have to write C# code. It would be helpful for the MSBI training candidate … Continue reading

Posted in MSBI, Uncategorized | Tagged , , , , , , | Leave a comment

SSIS, SSAS and SSRS(MSBI) interview questions: – Explain Data Flow Tab and Data Flow Task in SSIS?

When we think about creating any SSIS package, after we open the SQL server data tools or Business Intelligence development studio we will landed into SSIS designer window. As you can see SSIS designer contains many tabs at the top. … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 1 Comment

SSIS, SSAS and SSRS(MSBI) interview questions: – Explain the following terminologies in SSIS

Control Flow In SSIS Package Control Flow defines the tasks to be executed. Example: We define operations such as “Execute TSqlCommand on Database”, “Send Mail” etc. in Control Flow. Precedence Constraints In the control flow section of SSIS designer we … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment