Package-EE38-dtsx.txt

FileSize.JPG

<div>
Thanks fo the attachment. It is very helpfull for beginners in SSIS like me. I really appreciate it. If i need furthur clarification , i will let you know.
</div>


Thanks fo the attachment. It is very helpfull for beginners in SSIS like me. I really appreciate it. If i need furthur clarification , i will let you know.

<div>
<div class="content wysiwyg-content">
My Client is transferring 83 specific files every one hour in one particular folder. <br />
1.I need to find out each file size in the folder<br />
2.If any one of the file sizes is 10 times bigger than that particular file average size then need to send email to my team via SSIS. <br />
Can you help me how to do in SSIS? <br />
Thanks.<br />

</div>
</div>


My Client is transferring 83 specific files every one hour in one particular folder. 
1.I need to find out each file size in the folder
2.If any one of the file sizes is 10 times bigger than that particular file average size then need to send email to my team via SSIS. 
Can you help me how to do in SSIS? 
Thanks.


How to find each file size in the given folder via 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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.