sql server data tools dynamic file name for flat file source
<p>I've got a ssis package that does a simple enough data import from a text file into a database table. The import file name needs to be configured as a dynamic source since the file name will change. So my file name will have following pattern:
bookNames_Shopping_05_02_2016.txt  --> bookNames_Shopping_ will be <em>constant</em> but the date stamp will <em>change</em>. </p>

<p>I set up a variable called <em>filename</em>, and in the connection manager's properties window, I set the ConnectionString property to @[User::filename]. How do I set the filename variable to read the file name that is in the folder that the connection manager is pointed to? 
P.S. I know it can be done inside a For Each loop but since I don't have multiple files but a single file that needs to be processed, I **don'**t want to use the for each loop.</p>

<p>Full path for the file: \XYZYUC3312B6\SHARE\Bound\bookNames_Shopping_05_02_2016.txt</p>