Abstract
You can accomplish a lot with standard transformations, but sometimes the Script Component provides an easier solution. For example, a nested if construction is very possible in a derived column, but it becomes unreadable and unmaintainable if you have a lot of levels or conditions. And some features are just not available in the out-of-the-box components. This chapter shows some of the situations where a Script Component is useful.
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). Script Component Transformation. In: Extending SSIS with .NET Scripting. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0638-6_11
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0638-6_11
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)