DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Average: 4 (3 votes)


Overview

Script task to manage IFileInfo list.


Setup

The script 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 for implementing parameters user interface.


Library references

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

ScriptMain