Set a foreach to a file connection

[ChrisW]

Hiya,

So I am in SQL Server Business Intelligence Development Studio 2008. I
have a Foreach file enumerator and a file connection that points to a
folder. I only see browse and can only enter a folder path text under
the foreach properties now (enumerator configuration). But I really
need to set the folder dynamically and from sql server when the
package is schedule to run.

How do I get the foreach to use the file connection for the folder
path?

ChrisW

[Mark Fitzgerald]

Easiest way to do this is :

1. Create a string variable with the original file folder path you need.
2. Give the variable a value by :
a. Create a SQL based SSIS configuration holding the variable value
so this can be changed remotely.
b. Run an Execute SQL Task with a output parameter which is the
variable created earlier.
3. Within the ForEach Loop Editor choose to set an expression (collection
path top box). Set the Directory property as the value of the variable
created earlier.

Fitz

"ChrisW" <chri...@gmail.com> wrote in message
news:d74d0f3a-3e2a-4326...@b30g2000yqd.googlegroups.com...