<div>
<a href="https://www.experts-exchange.com/questions/23451603/Using-SSIS-to-check-SFTP-site-and-only-download-once-file-is-done.html" rel="ugc">https://www.experts-exchange.com/questions/23451603/Using-SSIS-to-check-SFTP-site-and-only-download-once-file-is-done.html</a>
</div>


https://www.experts-exchange.com/questions/23451603/Using-SSIS-to-check-SFTP-site-and-only-download-once-file-is-done.html [https://www.experts-exchange.com/questions/23451603/Using-SSIS-to-check-SFTP-site-and-only-download-once-file-is-done.html]

<div>
<div class="content wysiwyg-content">
I have an SSIS package which imports file contents.<br />
<br />
Sometimes these are blank files and I need SSIS to just move them to another directory.<br />
<br />
Is there a feature in SSIS which would return the file size, and if it is smaller than x bytes, it just places it in another directory?<br />

</div>
</div>


I have an SSIS package which imports file contents.

Sometimes these are blank files and I need SSIS to just move them to another directory.

Is there a feature in SSIS which would return the file size, and if it is smaller than x bytes, it just places it in another directory?


SSIS - file import - detect file size

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.