How to run just n number of rows
We are in the process of converting from one ETL tool to Data Services 3.0. I have gone through the tutorial and searched the forum, but could not find a way to run the first n rows of source. For example, my source has 3000000 rows, but instead of running all the rows through the job, I just want to run the first 1000 rows to make sure I am getting my desired result before running all 3000000 rows.
You could include a where clause on the query that is pulling the data to just restrict it to a subset of rows.