No problem. If you get hung up getting parameterized jobs and Loop to work, just post a question. After you get one of these working you'll be comfortable with it and use it all the time. The three keys to remember are:
A job parameter is really just a macro variable. The macro variable will be set by Loop before the parameterized (inner) job runs, so can be used anywhere in the parameterized job (file/table names, augmenting the where clause in queries, etc).
Every row passed to the Loop transformation results in an execution of the parameterized (inner) job and every column can be (but doesn't have to be) mapped to a parameter of the parameterized job as part of Loop configuration.
If you only need one iteration - meaning you just want to invoke a parameterized job in several contexts, from several jobs to reuse logic - you don't need multiple rows going to Loop. In fact, all you have to do is make sure the job parameter macros get set before you invoke the parameterized job, which can be done with Loop or just through user written code.
Thanks,
Tim Stearn
... View more