March 24, 2014 at 8:45 am
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.
March 24, 2014 at 8:52 am
Is the value set from an expression? E.g. it's re-evaluating the expression when you re-open it?
March 24, 2014 at 10:19 am
The file name comes from a user defined variable [User::FileName].
March 24, 2014 at 10:27 am
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.
March 24, 2014 at 2:31 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy