Chapter 8. Advanced Features of Integration Services

In This Chapter

Logging and Log Providers in SSIS

Transactions in Integration Services Packages

Restarting Packages with Checkpoints

Expressions and Variables

Handling Events at Package Run-time

Summary

You’ve worked with various tasks of control flow and have used various features and properties of the tasks to configure your package to perform a job. In this chapter you will learn about some of the advanced functionalities inbuilt into Integration Services that you can leverage to extend functionality of your packages.

You will learn about logging and log providers in Integration Services, which help you to monitor the events at run-time and provide auditing abilities. Transactions help you ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial