File Info List Task

Your rating: None Average: 1 (4 votes)

Overview

Script task to manage IFileInfo list. The task has the following parameters:

  • InfoList – selects variable containing IFileInfo list.
  • Action – selects task action:
    • AscendingSort – sorts the list in ascending order.
    • DescendingSort – sorts the list in descending order.
    • First – returns first Count items from list.
    • Last – returns last Count items from list.
  • OrderBy – selects which IFileInfo member to use for list action.
  • Count – specifies number of items to return.

Requirements

Depends on COZYROC Script Task Plus component for implementing parameters user interface.

Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus

ScriptMain