Creating rows from a range

Just wanted to shout out to Advanced ETL Processor team. I found this example of code in the demo data. I created a view to get my min and max of the data. I then add a few extra to the max amount and then unpivot my resulting string. I then use ETL to add the new rows only. Works brilliantly!! I then created a package to run 10 times. In other words, I batch it for a 1000 rows at a time. I thought it best to do than rather than have my buffer variable be to long to work with.

Excellent and useful post !!!