Using the Premium File Properties Task

The Premium File Properties Task is a control flow component that can be used to:

  1. Read the properties of a file from a path
  2. Update the properties of a file from a path

There are two pages that can be configured.

General

The page includes the general properties for the component.

Premium File Properties Task

Connection Manager

The Connection Manager drop-down will show a list of all connection managers that are available to your current SSIS package.

This component will support the following connection managers:

  • Local File
  • FTPS Connection Manager
  • SFTP Connection Manager
Source Path
Specify the source file path to read
Item Selection Mode

The Item Selection Mode settings specifies what sub items (if any) you wish to retrieve. The available modes are:

  • Selected Item: Retrieves only the item specified at Source Item Path
  • Recursive: Retrieves the item specified at Source Item Path and its sub items recursively.
  • Selected Level: Retrieves the item specified at Source Item Path and its sub items.
  • Recursive (Files Only): Selects items the same as the Recursive mode but only returns files.
  • Selected Level (Files Only): Selects items the same as the Selected Level mode but only returns files.
Action

There are two actions that can be chosen:

  • Read File Properties
  • Update File Properties
Multiple Matching Handling

The below could be chosen to handle multiple matches:

  • Largest File Size
  • Newest File (Creation Date)
  • Newest File (Modified Date)
  • Oldest File (Created Date)
  • Oldest File (Modified Date)
  • Smallest File
  • Write to All Matches
Filter Parameters
This grid allows you to specify filter parameters. You can choose a property, and then assign a filter condition to it to read the files.
Property Output Mapping

This grid would vary depending on the Action that is chosen. If the action is to read the file, then the properties to read can be chosen. If the action to update the file properties is chosen, then the properties that can be updated can be chosen in the field. This would also allow you to specify the value to update.

Note: When reading a property value, the values can be assigned to a variable that can be chosen from the grid on the right side of the component.

Error Handling

This page can be used to handle the errors.

Premium File Properties Task

Fail on error
This when chosen will fail the component on error.
Write error to variable
This can be used to write the error message to a variable.
Ignore error
This can be chosen to ignore the error and continue the task.