Suppose I have two identical databases, the first is the staging that
all development stuff gets reviewed before the roll up and the second
one that is the production.
Is it possible in SSIS to have an OLE DB Source Data Flow item that is
parameterized, so if I change the value of the parameter, all the Data
Flow Items will work on a different source database?

Hello KelMan,

Yep

Look at the Connection Manager properties for the connection. Now look for
a property called Expressions.

In their you can set the properties of the Connection Manager to variables
(amongst other things). These are then evaluated and populated with whatever
value the variable contains at the time

Very similar to this

http://wiki.sqlis.com/default.aspx/S...cLocation.html



Allan

Yes, found it... Thanx!