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.
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 name of the job and # prepares it for data flow input parameter print('INFO: scr_init script has started...'); while ($l_JobName IS NULL) begin if ($g_JobName IS NOT NULL) begin print('INFO: assigning $g_JobName value' ...