Actually, miscellaneous groups include almost all types of functions that cannot easily be categorized. Among miscellaneous functions, there are functions that allow you to extract useful information from the Data Services repository, for example, name of the job, the workflow or dataflow it is executed from, functions that allow you to perform advanced string searches, functions similar to other standard SQL functions, and many others. Throughout the book, we will very often use Data Services miscellaneous functions. So, in this recipe, we will take a look at some of those that are usually used in the scripts and help you query the Data Services repository.
At this point, you should be pretty comfortable creating new jobs, script objects, and dataflow objects. So, I will not explain the steps in detail every time we need to create a new test job object. If you forgot how to do it, refer to the previous recipes in the book.
Create a new job and add...