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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics