I'm trying to set the connectionstring property of a Flat File Connection. When I try to use a variable, I only see the package level variables. How do I get an expression to use a variable scoped at the container level variables?

You can't.  Connection Managers are package scope objects (you can use them at any level - they can't be limited in scope).

Ok. I admit I was hoping for a different answer but from what I see it makes sense. Connections are for packages so they only see package variables.

But........ I did find away around it. Use a script component or script task in the sequence or data flow to apply the value of the "lower" variables to the connection. Absolute money! Worked like a champ. :)

Hi Abercrombie07, how can i do that i tried to add a script component but didnt know how to configure it.

Thank you