Hi
Is there a VC function to generate random numbers?

Don't think so. You can make one fairly easily using c#, powershell or even an sql function. Put it it in a separate job/task and call it from wherever you need to.

I solved it by adding milliseconds to the time-date that I put on the filename, then the filename got unique.

For future reference, in situations like this where what you really need is a unique string, and the subset of those situations where length isn't an issue, and milliseconds isn't appropriate for whatever reason, there is a String.GUID under Functions.

There may also be circumstances in which the job or task unique execution IDs would be helpful for similar purposes.

thats exactly what I'm looking for.

Regarding length it could be adjusted by:

{STRING(Right|{STRING(GUID)}|6)}

or any number but 6, depending on length.

There is a file function that could be used also. Hadn't seen this one before:

thats exactly what I'm looking for.

Regarding length it could be adjusted by:

{STRING(Right|{STRING(GUID)}|6)}

or any number but 6, depending on length.

Just keep in mind that truncating a GUID means a corresponding increase in likelihood of collision.

What thomas wrote is the best method if you want just numbers

Powershell script
Get-Random -Minimum -000001 -Maximum 999999

What thomas wrote is the best method if you want just numbers

Powershell script
Get-Random -Minimum -000001 -Maximum 999999

Thanks, Joey and Thomas for your help and contribution on this issue.