Post reply

For Each Loop works on first pass but not on second

  • October 14, 2010 at 4:06 pm

    #157262

    Alright I'm having an extremely wierd problem. Let me briefly describe what this step in the package is doing.

    1. dataflow populates an ado record set with employee numbers and their userids

    2. For each loop uses said ado record set and process each row and passes columns rows to variables.

    3. Inside of the for each loop first a ssis script task takes those variables and builds in to an array with some other hard coded values.

    4. 2nd and final step in the for each loop makes a web service call and passes that previously built array to the web service method.

    This package has ran successfully in a 32 bit production environment for months and still runs successfully in 32 bit development desktop environment.

    When ran on our new 64bit production server the package completes all the way through the first pass of the for each loop. I can literally see the webservice call has succeeded and done its job creating a corresponding database record in a vendors application. On the second pass the webservice call fails basicly stating the array is not complete. It's almost like on the second pass the script task doesn't run or the for each loop doesn't process the ado .net record set correctly.

    Has anyone had any problems with for each loops or scripts tasks in a 64 bit environment? This same 64bit environment runs multiple other ssis package with script tasks, but they are all less complex than this one.

    I've read the standard issues with script tasks that can be seen in a new 64 bit environment but I don't believe I'm experiencing the normal issues.

    Any ideas would be greatly appreciated. I've been beating my head against the wall on this one and I'm about to break down and open a case with microsoft.

    Thanks!!

  • October 21, 2010 at 12:55 pm

    #1240524

    I would recommend you use the event log to post trace messages from your script, to find out what is going on with your arrays. Otherwise it is a blackbox and you are left guessing.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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