SSIS foreach loop container NOT saving change

  • Does anyone have an answer for why when I make a change to a foreach loop container in a SSIS package it does not save?

    I am trying to change the base file name and if I change it through either the edit or properties windows, the changes does not save. Fore example i change the Files: or File Spec: from oldfile*.txt to newfilename*.txt and when I save and og bak into the edit area to confirm the change, the Files: section shows as "oldfile*.txt.

    Thanks for any input you migh have.

  • Is the value set from an expression? E.g. it's re-evaluating the expression when you re-open it?

  • The file name comes from a user defined variable [User::FileName].

  • Normally the @[User::FileName] variable would be set by the for each loop as it iterates around files.

    What I was asking is are there any expressions set in the properties of the for each loop itself (Right click on the For Each Loop container, properties and click the elipse under expressions).

    It would be pretty normal to make the path/wildcard for a for each loop parameterised and exposed in a config file, which would exhibit the problem you're seeing if you just tried to set the value directly in the loop. Are there any package configurations (SSIS->Package Configurations)? This property could also be being directly set by the config file, which will override anything you type in when the package is executed.

  • Thanks. Yes found the paths coded into a DTS config file. Changed inside that and now able to save change in dtsx package.

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

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