Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic



Buy Now Free Trial Download Compare Editions More Features

Task Factory File Properties Task

Reads the properties of any file and stores property in variable. Many companies receive large data files from outside their organizations and run the risk of loading the file prematurely during transmission causing an SSIS failure. Our File Properties Task gives you the power to eliminate this problem by determining if the file is in use or transmitted before loading. The File Properties Task additionally saves drive space by identifying old files ready for archive.

Feature Highlights

  • Used to read the properties of an existing file. 
  • Will read the properties like File Exists, File Size, File Name, File Content, Creation Time, Is File In Use, Hidden, ReadOnly and assign them to SSIS package level variables
  • Easy to use User Interface
File Properties Task

File Properties Task - Step 1

UI Overview

The File Properties Task is used to read the properties of a file and set package variable values based on the settings provided in the UI.

Task Settings

Source path is a -  The drop down has two values. Variable and Connection manager. Selecting "Variable" will change the "Select connection manager:" label to "Select variable" and populate the drop down next to it with all the string variables in the package. You must select a variable which contains a path to a file. 

Select connection manager / Select variable - Select a connection manager / variable that contains the path to the file of which the properties will be read.
Fail package if file not found: Selecting this option will stop execution of the SSIS package if the file is not found.

UI Overview

The File Properties Task is used to read the properties of a file and set package variable values based on the settings provided in the UI.

Task Settings

Source path is a -  The drop down has two values. Variable and Connection manager. Selecting "Variable" will change the "Select connection manager:" label to "Select variable" and populate the drop down next to it with all the string variables in the package. You must select a variable which contains a path to a file. 

Select connection manager / Select variable - Select a connection manager / variable that contains the path to the file of which the properties will be read.
Fail package if file not found: Selecting this option will stop execution of the SSIS package if the file is not found.

File Properties Task - Step 2

Properties Grid

The properties grid is used to assign file properties that will be populated during execution to SSIS package variables. 

To set a value, click on the right side of the grid and a drop down will appear.

You can either select <Create New Variable...> or select a variable from the drop down. The variables in the drop down will only be displayed if they match the type of property being set during execution. (e.g. CreationTime property is a date. Therefore only package level user variables with a type of DateTime will be in the drop down).

Properties Grid

The properties grid is used to assign file properties that will be populated during execution to SSIS package variables. 

To set a value, click on the right side of the grid and a drop down will appear.

You can either select <Create New Variable...> or select a variable from the drop down. The variables in the drop down will only be displayed if they match the type of property being set during execution. (e.g. CreationTime property is a date. Therefore only package level user variables with a type of DateTime will be in the drop down).

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works