Creating a script

Yes, technically we created our first script in the previous recipe, but let's be honest—this is not the most advanced script in the world, and it does not provide us with much knowledge regarding scripting language capabilities in Data Services. Finally, although simplicity is usually a virtue, it would be nice to create a script that would have more than one row in it.

In the following recipe, we will create a script that would do some data manipulation and a little bit of text processing before passing a value to a dataflow input parameter.

How to do it…

Clear the contents of your scr_init script objects and add the following lines. Note that every command or function call should end with a semicolon:

# Script which determines ...

Get SAP Data Services 4.x Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.