O'Reilly logo

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services by Régis Baccaro, Joost van Rossum

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 5

image

File Properties

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.

Getting All Properties

As shown in Figure 5-1, the built-in File System Task is good for copying/moving files and directories, and also for setting attributes, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required