Retrieves and optionally sets properties on a file in the SQL Server Integration Services Control Flow. Available properties include file existence, size, read/write locks, creation/last access/last modification date, and file attributes.

File Properties Task Features:
1. The Task is intended to read properties from a given file, and optionally update some of those properties.
2. The file name can be "hardcoded" (specified literally), specified by property expression, or supplied in a string-typed SSIS variable.
3. The Task can be configured to fail if the file doesnt exist, or it can be configured to always report Success and record whether or not the file exists in a boolean-typed SSIS variable.
4. The Task can attempt to open the file for reading and record whether it was successful or not into a boolean-typed SSIS variable. It can attempt a similar write test to check for exclusive file locks.
5. The Task can read the files length, creation date, last access date, and last modification date and place those values into SSIS variables. It can also read attributes of the file - such as the ReadOnly and Hidden attributes - into boolean-typed SSIS variables.
6. The Task can also be configured to update the files date properties (creation, last access, last modified), or attributes.

Requirements:
* Microsoft SQL Server 2008 or 2005

The license of this software is Free, you can free download and free use this server utility software.