Sorry if this is a simple thing, I just can't seem to get it working.  Ugh.

I'm following the example here:

http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx

I got stuck on this section:

The important part of this dialog is highlighted and that is "Expressions". Click on the ellipses and we will be taken through to the next screen where we can start to create the expression. In the screen that follows, from the Property column drop the list down and choose ConnectionString

In the 'Property Expressions Editor' window, i can't choose Property=ConnectionString.  I just don't have it in my list.  I'm using Visual Studio Ultimate 2010.  The article is discussing SQL Server 2005 SSIS.  Maybe something changed b/w the two versions, or maybe I'm just not doing something right.

This is a big problem, b/c when I try to set the OLEDB, I get this.

Nothing is being feed into the Loop tool, and thus nothing can be mapped to the destination table in my DB.

I thought I could just make up my own, intuitive Expression, as such.

That doesn't do anything at all. 

Can someone help me out?

Th

that expression on the name property in the foreach loop (second) image isn't very useful. It changes the name of the loop with the value of a variable you're filling in this loop.

Have you set an expression on the connectionstring property of the Flat File Connection manager?

For more info see: http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-foreach-loop-file.html