O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

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

Introduction

The Script task and Script component allow you to execute a custom Visual Basic or Visual C# code inside your SSIS package control flow or data flow. This way, you can perform complex operations beyond the capabilities of other built-in tasks and transformations. The Script task works like any other task in the control flow. You can use the Script component in the data flow as the source, transformation, or destination.

Both the Script task and the Script component have two design-time modes: you begin editing by specifying properties using the common editors for tasks and components that you are already familiar with, and then switch to a development environment to write the .NET code. The second environment is the Microsoft ...

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