my for each loop container won't loop

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

my for each loop container won't loop

Author

Topic

pizzazzz
Yak Posting Veteran

55 Posts

Posted - 2010-08-13 : 14:10:40

I have a Foreach loop container and "Foreach File Enumerator" property set. It points to a folder with several files, all .xlsx types.

within my loop i have a script task with code to show (MSGBOX) the name of the .xlsx file it encounters.

for testing I have 3 files in folder. however when i run my loop package, it it only show 1 file in my message box, and the color of the loop container turns yellow.

what am I missing, I want the loop container to show all files, in this case 3 message boxes, each displaying the name of a .xlsx file; and then turn the container green.

help!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-14 : 02:58:36

you mean the loop container still remains in yellow even after you close the msg popup? if yes, there might be some steps in script task which is acting like break point. Also are there any other error windows popping up?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

pizzazzz
Yak Posting Veteran

55 Posts

Posted - 2010-08-17 : 17:43:14

Hi - thanks for comment.

there are no error messages.

BUT i did set a break-point on the msgbox code and ran it and this time after i stepped through the code all of my test files popped up on the messages boxes. any explanation on what I am doing incorrectly?

thanks!

pizzazzz
Yak Posting Veteran

55 Posts

Posted - 2010-08-17 : 17:45:20

BTW - here's my code:
Public Sub Main()
'
'
'
MsgBox("The current file name is :" + Dts.Variables("currentFile").Value.ToString())
Dts.TaskResult = ScriptResults.Success
End Sub

pizzazzz
Yak Posting Veteran

55 Posts

Posted - 2010-08-17 : 18:03:46

when i step through the code this is the log messages i get:
SSIS package "Package.dtsx" starting.
Warning: 0x6 at Script Task: Debugging of more than one script task is not currently supported.
Warning: 0x6 at Script Task: Debugging of more than one script task is not currently supported.
SSIS package "Package.dtsx" finished: Success.

pizzazzz
Yak Posting Veteran

55 Posts

Posted - 2010-08-18 : 17:56:53

got this all figured out - thanks for your responses!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-19 : 14:26:05

its you msgbox which caused the block.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

pizzazzz
Yak Posting Veteran

55 Posts

Posted - 2010-08-20 : 11:56:00

got this all figured out - thanks for your responses!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-20 : 11:59:26

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources