SSIS: Setting properties on Foreach enumerators

Well, I thought for once that I might have been able to blog something about SSIS before Jamie did... but I was wrong. :)

All I wanted to do was to dynamically set the folder for a foreach file container in SSIS using an expression. It was not immediately obvious how to achieve this. I struggled through a few other blog posts and then eventually came across an obscure reference in the documentation. Friday afternoon I took a screenshot of the settings page, but I left the file on the workstation at work.

This morning I was reading through my RSS feeds and what do you know - Jamie now has a detailed post, complete with screen shots: SSIS- Expressions on ForEach enumerators

Print | posted on Monday, October 16, 2006 10:44 PM

Comments on this post

# can some one explain me abt how to use tasks in containers

Requesting Gravatar...
hi i am new to ssis
so plz can any one help me out
how to use tasks in containers
Left by surabhi susheel on Dec 02, 2008 5:28 PM

# re: SSIS: Setting properties on Foreach enumerators

Requesting Gravatar...
Have a look in at the tutorial SQL Server Books Online. It will walk you through creating a simple package in lesson 1 and then in lesson 2 it will take you through how to use a foreach container.
Left by Darren Gosbell on Dec 02, 2008 5:36 PM

# re: SSIS: Setting properties on Foreach enumerators

Requesting Gravatar...
where can i get examples for control flow tasks and maintenance tasks
do we really have any examples if so let me know
Left by surabhi susheel on Dec 02, 2008 5:39 PM

# re: SSIS: Setting properties on Foreach enumerators

Requesting Gravatar...
Foreach File Enumerator using Excel files
Left by SQL Lion on Jun 19, 2009 5:03 AM

# re: SSIS: Setting properties on Foreach enumerators

Requesting Gravatar...
For more information on For each loop enumerators (Foreach File Enumerator using Excel files) and programming integration service (SSIS) using C# .Net and VB .Net, please visit the below link:
http://www.sqllion.com/2009/06/programming-foreach-loop-container-–-enumerating-excel-files/
Left by SQL Lion on Jun 19, 2009 5:04 AM

# re: SSIS: Setting properties on Foreach enumerators

Requesting Gravatar...
Interesting,

it would be great if you could provide more information...

Anyway, thanks for the post
Left by software development uk on Oct 13, 2009 6:19 PM

# re: SSIS: Setting properties on Foreach enumerators

Requesting Gravatar...
@software development uk: The post of Jamie's that I linked to has all of the detailed information.
Left by Darren Gosbell on Oct 13, 2009 9:15 PM
comments powered by Disqus