SSIS - Maintenance Plan Tasks
In using SSIS you will have noticed a section in the toolbox labelled
Maintenance Plan Tasks. You will have seen in there tasks like "Execute SQL
Task". You may be tempted to use these in your package.
DON'T
These
are tasks that are designed to be used in maintenance plans and not in normal
packages. These tasks have built in looping for iterating over databases and
have custom error handling to ensure that the package works as expected in a
maintenance plan, (generally continue on failure) unlike in a normal package
which is to fail.
This
was highlighted with SP2 which introduced a number of bugs with these components
resulting in you maintenance plans not doing what they were supposed
to.
So
make sure you only select the tasks from the main “Control Flow Items”
section.
-