<div>
&gt;Any help will be appreciated.<br />
Well in that case, off the top of my head.<br />

<ul>
<li>ForEach File Loop, loop through a folder.</li>
</ul>
<ul>
<li>Add logic somewhere that matches each file in the loop to your custom logic, setting the result to a variable defined as bit/boolean. &nbsp;Off the top of my head you may even be able to add this logic in the Loop in a textbox along the lines of 'Files to Compare'. &nbsp;If that is correct the disregard the green arrow thingie below.</li>
</ul>
<ul>
<li>Precedence constraint (aka green arrow) from above line, when bit/boolean variable is True, to your FTP task when uses that file variable. </li>
</ul>
</div>


>Any help will be appreciated.
Well in that case, off the top of my head.

 * ForEach File Loop, loop through a folder.

 * Add logic somewhere that matches each file in the loop to your custom logic, setting the result to a variable defined as bit/boolean.  Off the top of my head you may even be able to add this logic in the Loop in a textbox along the lines of 'Files to Compare'.  If that is correct the disregard the green arrow thingie below.

 * Precedence constraint (aka green arrow) from above line, when bit/boolean variable is True, to your FTP task when uses that file variable.

<div>
Yes, use an expression. That's what they are there for.
</div>


Yes, use an expression. That's what they are there for.

<div>
The solution provided by expert did not worked.
</div>


The solution provided by expert did not worked.

<div>
<div class="content wysiwyg-content">
I'm trying to setup a FTP task with SSIS that will download the file with a specific name. The issue is that the filename is dynamic, for example today the file name would be <br />
<br />
sample_20170419.txt and tomorrow that will change to sample_20170420.txt.<br />
<br />
how do we achieve this using SSIS? Any help will be appreciated.
</div>
</div>


I'm trying to setup a FTP task with SSIS that will download the file with a specific name. The issue is that the filename is dynamic, for example today the file name would be 

sample_20170419.txt and tomorrow that will change to sample_20170420.txt.

how do we achieve this using SSIS? Any help will be appreciated.

Receive Files with particular name from FTP server using SSIS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.