O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

There's more...

The issue faced many times with SSIS load applications is that collecting execution statistics and messages are not built up front. In the past, before the SSIS catalog facilities, developers needed to add substantial elements, such as Execute SQL Tasks in the various event handlers or add row counts and variables in every child package. This was most of the time accomplished by using template packages, packages that contained all the necessary plumbing. They were then adapted to the load tasks necessary to load data. When these templates were not used up front, developers needed to open all developed packages and modify them. With medium to large sized project's that had 50+ packages, this task was tedious and most of the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required