Script Component Foundation

  • Joost van Rossum
  • Régis Baccaro

Abstract

If you have an abnormal flat file format, or you want to use regular expressions to clean your data, or you need an XML destination, then the Script Component is one of your best choices. The Script Component is part of the data flow in SSIS; it provides a scripting editor for you. It can be used as a source, a transformation, or a destination. In this chapter, you deep-dive into the Script Component and some of the most common usages of this component. You will learn how to use variables, connection managers, logging methods, and error handling in a Script Component.

Keywords

Visual Studio Connection Manager Output Column Script Type Script Editor 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-0638-6_9_MOESM1_ESM.zip (134 kb)
978-1-4842-0638-6_9_MOESM1_ESM.zip (zip 1 kb)

Copyright information

© Joost van Rossum and Régis Baccaro 2015

Authors and Affiliations

  • Joost van Rossum
    • 1
  • Régis Baccaro
    • 1
  1. 1.XE BaarnThe Netherlands

Personalised recommendations