For those that downloaded the enhanced error component I
forgot to make it clear that the new version requires you to have service pack 1
installed. The reason being is that we are using an interface that allows us to
look at the whol package in the component UI.
If you were around at a SSIS presentation in 2005 you will have seen the
statements on the extensibility. The statement from MS was that they have used
exactly the interfaces we do to create their components. However on
investigation we couldn't figure out how they had written the Slowly Changing
Dimension to add components using the public interfaces. Well what was missing
was the pipelineService that was made public in Service Pack 1.
So you can now write components just like Microsoft. If you are interested in
the code for the error component let me know.
In the meantime feel free to download the component from here
http://sqlblogcasts.com/files/folders/transforms/entry2.aspx