Autogenerate insert value like excel

bani06 · July 18, 2021, 9:30am

Hi,

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 ?

thanks.

bani06 · July 18, 2021, 2:03pm

nscheaffer · July 19, 2021, 2:44am

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?