As you know, jobs don't work with datasets. Transformations do. However, you can still use the Job Executor to send the rows to the Job. Then, any transformation executed by your Job can get the rows using a Get rows from result step. By default, the Job Executor executes once for every row in your dataset, but there are several possibilities where you can configure in the Row Grouping tab of the configuration window:
- You can send groups of N rows, where N is greater than 1
- You can pass a group of rows based on the value in a field
- You can send groups of rows based on the time the step collects rows before executing the Job