SSIS 2008 - Viewing Variable Values at Runtime

It looks perfectly fine! The first parameter User:FileIDS looks like it's received the ResultSet of the Execute SQL Task (GetFileID FromDtabase) fine. Of course it's an object so you don't see the actual result set but you can examine it further by expanding the variable (click on the plus sign) to see for instance the row-count etc.

The second parameter User::FileID doesn't show any value because it's used in the context of your Foreach Loop Container, so although it's accessible at the package level, but it won't be set until the first iteration of your loop is completed.

Hope that makes sense.

Ok,

If I copy the SQLStatement in the Execute SQL Task (GetFileID FromDtabase) to: SQL Server using Query

I can see that there are 3 with a 36 count = 108 records

Why I can not see that when I do this view variables?

I am selecting
Set Breakpoints:
Break when the container receives the OnPostExecute event

Is that the wrong event?
I am just trying to understand better

Thanks

Great thanks