Tuesday, 10 September 2013

SSIS Foreach Loop with visual feedback

SSIS Foreach Loop with visual feedback

I have a foreach loop container in my SSIS package which iterates about 30
.mdb (Access 2000) files.
These files can be quite large (up to 1GB), so I would like some sort of
'visual feedback' to show which file is currently being iterated, either
as a file name or as a 'currently on x out of y files'.
Is there any way to dynamically show this during execution of a package?
Pehaps dynamically updating the name of a box?
I am using SQL Server / Visual Studio 2005
Thanks in advance.

No comments:

Post a Comment