Post reply

SSIS ForEach Loop container issue

  • December 20, 2007 at 4:54 pm

    #122767

    Hi

    We have an issue with an SSIS package with a ForEach loop that will not save changes to the T-SQL command in the Data Flow Task within the loop.

    Changes made OUTSIDE the ForEach loop container are saved fine.

    Has anyone seen this before?

    Thanks much,

    Andy

  • December 20, 2007 at 6:31 pm

    #761962

    Do you receive any errors or are the intended changes simply discarded? What type of T-SQL statement are you running inside the loop? Is there perchance an open transaction?

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • December 21, 2007 at 10:10 am

    #762202

    Hi Tim

    No errors at all. You close the editor for the ForEach loop action and you open it back up and no change! Very weird.

    No tran is open that I know of.

    We just found out from our software developers that they added some logic in the background of the package that *might* prevent editing. Once I get that info I will post here in case someone else runs into this.

    Thanks

    andy

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

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