Autogenerate insert value like excel


I have 5 user name to insert to 1000 row repeatably. How to do it in Data Services to generate automatically the 5 username insert to 1000 row ?


I have no experience with Data Services, but perhaps you could create a variable based on the BIL column that uses the modulus operator?

Here a demo with SQL Server code.

Does that help at all?