I would like to create a package that connects to a fixed database
table, retrieves from there the name of an excel file to get data from,
and gets the data.

Basically the question is: can I configure the connection managers
dynamically?

I know I can do it programmatically, but this would mean to do
everything in the package programmatically, while I would like to make
the other tasks of the package visually from the SQL Server Business
Intelligence Development Studio.

Is it possible? Any other idea to solve it?

Hello cgian31,


You should be looking at Property Expressions. You may also want to take
a look at Configurations


Allan

In fact what I have done is to use a script task inside a foreach loop.
Via the script task I assign to the connectionstring property of the
connection manager a value which comes from another table I import.

The connection Managers can be configured ideally through one of two methods

1. Configurations
2. Property Expression

Thanks


Allan

"cgian31" <cgian31 (AT) katamail (DOT) com> wrote