Hello,
I have just developed my first full package and it has been, ahem, an adventure- but I can see the power of SSIS. I am splitting 1M rows in to up to 11 parts (therefore up to 11M rows) for several files and it takes a matter of seconds!
I have used some variables in the package and would like to see the results of these at the end of execution. They are purely for interest at the moment.
I think I can output them to a flat file, but is it possible to output them to the Immediate window at the end of execution?
I can not figure out how to have a watch on them either- is this possible? Ideally I would like a counter on screen next to my loop containers.
All of the web pages I have seen regarding debugging seem to assume that VB is being used to create the package.
Thanks,
Alan.
I'm not sure how the output the variables to the Immediate window. You could log them, or output them to a flat file, as you suggested.
You can put a watch on them. To do this, set a breakpoint on a task (right-click on it). Pick on towards the end of your packageif you want to see the values at the end. When you run the package and it hits the breakpoint, you can type the variable name into the watch window.
|||You could also use a script component to issue a MsgBox, but that would only be handy when debugging.
