SSIS ForEach Loop container issue

  • 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

  • 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

  • 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