File Properties Task Retrieves and optionally sets properties on a file in the SSIS Control Flow
Download

File Properties Task Ranking & Summary

File Properties Task Tags

SSIS file properties changer retrive file properties Retrive File Properties

File Properties Task Description

The File Properties Task package will allow users to retrieve and optionally set 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. Main features: The Task is intended to read properties from a given file, and optionally update some of those properties. The file name can be "hardcoded" (specified literally), specified by property expression, or supplied in a string-typed SSIS variable. The Task can be configured to fail if the file doesn't exist, or it can be configured to always report Success and record whether or not the file exists in a boolean-typed SSIS variable. 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. The Task can read the file's 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. The Task can also be configured to update the file's date properties (creation, last access, last modified), or attributes.

File Properties Task Related Software