CHAPTER 4
Script Task
If you want to work through SFTP (SSH File Transfer Protocol), or if you want to automate sending a highly customized email, or applying passwords on files, or checking file properties such as creation date and modified date, then the Script Task is one of your best choices. This chapter dives into the Script Task and some of its most common usages, including how to use it with variables and connection managers, how to use it with logging and error handling, and how to reference custom assemblies.
Editor
When you add a Script Task to the Control Flow and edit it, you first have to choose the Script Language: C# or VB.NET ...
Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
