File Properties Source

Your rating: None Average: 2 (1 vote)
Script File: 
FilePropsSource.2005.scx
FilePropsSource.2008.scx

Overview

Source data flow component, loading file properties. It has the following parameters:

  • IsSearchPathVariable – specifies if search path is variable.
  • SearchPathVariable – search path package variable.
  • SearchPath – search path.
  • IncludeSubfolders – specifies if sub-folders have to be included.

Requirements

Depends on CozyRoc Script Component Plus component for implementing parameters user interface.
Requires installation of CozyRoc SSIS+ 1.4 library.

Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus

ScriptMain

»