2015•Apress eBooksRequires access

Script Component Foundation

Joost van Rossum, Régis Baccaro

Open publisher page 0 citations

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. 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.

About this research paper

What this paper is about

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. 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.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available 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. 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.

Key concepts: Component (thermodynamics), Scripting language, Computer science, XML, Database, World Wide Web, Programming language, Physics

Related papers

Back to paper searchBrowse research topicsOriginal source
Script Component Foundation — Research Paper | ScholarLens