SSIS - Change your GUIDs
Did you know that your package has an identifier in it?
Well it does and it can be used to provide automated reporting of your
package executions. Using the eventhandlers you can log information to a central
store to provide easy reporting.
The key for this to work is to use the identifier for the package so you will
be able to distinguish between packages that are running and logging to the same
database.
However if you are using best practices and working with template packages
then you may find that all your packages have the same identifier. By default if
you reuse a package the identifier doesn't change. So what can you do.
Well in the package there is a ID property that you can regenerate. To
do this,
1.
Open your package.
2.
Click on the design sruface of the control flow. This selects the
package
3.
In the properties window there should be an ID property.
4.
If you click on it there should be a drop down, with one option
"<Generate New Id>"
5.
Clicking on this will generate a new Id
Once done this generates a new ID. It doesn't generate new IDs for the tasks
in your package. For this reason in your logging solution when you log the
status of a task you need the package ID AND the task ID to be able to uniquely
reference the task.
-