Logging is a features which creates the records that traces the execution of tasks and containers with in the package.
Steps to configure loggings: Open Business Intelligent Development studio and configure a package----------------> In control flow, right click and select logging----------------> Check containers check box----------------> In provides and logs tab, Provider type –Select SSIS log provider for Text Files
Aspired to become a MSBI Developer? Explore the post to discover the know-hows on MSBI Training.
Click Add----------------> Check newly added log provide check box----------------> In configuration header, select new----------------> Usage Type –Select create File Option File – Click Browser----------------> Provide file Name(logged information.txt) And check open---------------->
Learn more about MSBI Interview Questions in this blog post.
Click ok Select Details tab, Check events check boxes on which you want to capture log information on error, on warning, on Query Failed, on pre execute ----------------> Click Advanced button----------------> Click ok to save the changes done
For an Indepth knowledge on MSBI click on:
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
