Changing ForEach Loop Container Directory Property
I've got all my needed variables being set in a package configuration file finally. Only piece I'm still missing is the I need the Directory property to be set to my @OutPutFileDirectory variable which I set in the package config file. For many
of the other settings I could select connection string in the expressions and enter a variable. But the drop down in the ForEach Loop Container doesn't show the Directory property as an expression that I could change.
Is there a way to do this from the package config file setting?
February 28th, 2011 3:57pm
The Directory property is the property of the collection rather than the property of Foreach loop itself. This is why its present under the Expression under the Enumerator on the Collections tab of Foreach loop editor. If you click the expressions here you
will find the desired Directory property and you can use expression to build the pattern.
Reply taken from an external sourceArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 4:04pm
Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
February 28th, 2011 4:04pm
You are correct - that threw me
http://blogs.msdn.com/b/changliw/archive/2010/07/19/ssis-dynamically-specify-folder-path-for-foreach-file-enumerator-in-foreach-loop-editor-task.aspx
Thanks for the help
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 4:10pm