> Is there an easy way to dynamically configure DataFlow tasks in your
> package? For example, I'd like to be able to pass in a variable for
> the name of the source and destination tables, and have the package
> read the metadata for these tables in the dataflow task.
>
> In DTS you could do this, but in SSIS I don't see an easy way to do
> it.
>
> Thanks in advance.
>

> This is great. However, how are you suppose to make use of variable
> names when the metadata is saved with the package? I don't undestand
> the logic behind the use of variable names for the tables when the
> metadata isn't updated automatically.
>
> Would you create an eventhanlder for the preexecute event of the
> dataflow task, then programmatically updated the metadata at runtime?
>
> This seems like a fairly common and simple thing to do, but I don't
> seen any real samples that would show you this actually works.
>
> Thanks for your help.
>