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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Joost van Rossum and Régis Baccaro
About this chapter
Cite this chapter
van Rossum, J., Baccaro, R. (2015). File Properties. In: Extending SSIS with .NET Scripting. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0638-6_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0638-6_5
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0639-3
Online ISBN: 978-1-4842-0638-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)