Post reply

Package Validation Error

  • March 11, 2010 at 6:24 am

    #143517

    Can anyone help with the following issue?

    I have created a package that uses a DataReader Source and a RecordSet Destination to generate a Recordset and assign the values to an Object variable.

    This is connected to a ForEach Loop within which I have set up "ForEach ADO Enumerator and set the ADO source to the Recordset Object variable. I have also created and mapped variables to the recordset fields. All variables are at the Package level.

    The ForEach Loop container carries a Script Task which simply returns Dts.Variables("User::ECData").Value.ToString) - to check that the package is running.

    When I run the Package debugger I am getting the following error message:

    >>>Package Validation Error

    Additional information:

    Error at For Loop Container: The evaluation condition expression on the For Loop "For Loop Container" is empty. There must be a Boolean evaluation expression in the For Loop.

    (Microsoft.DataTransformationServices.VsIntegration)<<<<<<

    Can anyone shed any light on what I am missing or have done wrong to get the message? The message indicates a For Loop when I have used a ForEach Loop and it appears to be looking for a Boolean value but i thought that the Ado Enumerator would run until the Enumeration Mode is satisfied - Set to Rows in First Table.

    Thanks,

    Ian

  • March 11, 2010 at 7:03 am

    #1131997

    Guys I found the answer to this.

    In looking at the Control Flow panel there was no "For Loop" present but when I checked the Package Explorer panel there was a For Loop in the executables folder. As soon as I removed this my error dissapeared!

    Simple when you know how.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply