I do not believe we’d reach a size limitation - after all, all of the current scripts have the email addresses hard-coded in them, and that would be our starting point. The reason for moving them to a database is so that we can easily cross reference terminated employees and remove their emails without having to edit every single script.
The concatenating can actually be performed via SQL Server and delivered to the variable - I’m just not sure how to set up the variable correctly, that’s all.
Last thought: Is there any chance that TDP will one day have some ‘built in’ variables that capture items like the current file name (ie. an automation script runs, and a built in variable captures the file name of the automation script), or other environmental pieces that could be useful in automation?