Advertisement

File Properties

  • Joost van Rossum
  • Régis Baccaro

Abstract

The built-in File System Task in SSIS does basic operations on files, such as copy, move, and delete. Sometimes, however (especially in data transfer scenarios), you want to find the most recent file, or you want to check whether a file is locked or if it is read-only. In these situations, Script Task is useful in getting help from .NET libraries such as System.IO.File. This chapter presents some very common usage examples of working with files within Script Task.

Keywords

Precedence Constraint Creation Time File Property Connection Manager Package Variable 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-0638-6_5_MOESM1_ESM.zip (2.5 mb)
978-1-4842-0638-6_5_MOESM1_ESM.zip (zip 1 kb)

Copyright information

© Joost van Rossum and Régis Baccaro 2015

Authors and Affiliations

  • Joost van Rossum
    • 1
  • Régis Baccaro
    • 1
  1. 1.XE BaarnThe Netherlands

Personalised recommendations