Baskar B.V (8/13/2010)
tripower (8/13/2010)
I wanted to create a pause with a warning message at the beginning of certain packages due to the potential impact on the database. How would I do this with SSIS?You can do that using Msgbox inside activex script task.
Hello Baskar,
I'm sure that we all BI-developers are of the believe that ETL processess should not include much of UserInteraction as they are a set of automated process.
In this case, Well my approach would be to create Event Handlers as and when necessary so that the package continues to run and log the necessary details as and when the need arises rather than using a messageBox.
I am keen to know if i'm mistaken.:-):-)
Raunak J