Hi all, please inform me as to why the following parameters for an Execute SQL Task and Foreach Loop Container are not right. This format is almost identical to a book I am reading but it is not working! The variables themselves are scoped to the package and everything else here seems correct but being new to SSIS I am not understanding the errors which are:

I know that the SQL statement outputs all of the rows that I want because I built it and the SQL Task completes successfully but the Foreach Loop stops. There are only 26 rows from this table for now so I know that the enumerator should have been able to retrieve the element at index 1 but for some reason it does not. Any ideas? Please?

Execute SQL Task

General:

ResultSet = Full result set

SQL Statement:

ConnectionType = OLE DB

Connection = MICHAEL-PC.EconAnalysis

SQLSourceType = Direct input

SQLStatement = SELECT Table_Links FROM dbo.tblLinks

BypassPrepare = True

No Parameter Mapping

Result Set:

Result Name = 0

Variable Name = flObj (of Object datatype)

No Expressions

Foreach Loop Container

Collection:

Enumerator = Foreach ADO Enumerator

ADO object source variable = User::flObj

Rows in first table selected

Variable Mappings:

Variable = User::sDbName

Index = 1