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

Unleash the Power of SSIS Script Task and Component

In this chapter, we will cover the following recipes:

  • Using variables in SSIS Script task
  • Execute complex filesystem operations with the Script task
  • Reading data profiling XML results with the Script task
  • Correcting data with the Script component
  • Validating data using regular expressions in a Script component
  • Using the Script component as a source
  • Using the Script component as a destination

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