Search code examples
ssisfilenames

SSIS how to build unique filename in Expression

I would like to create random unique filename in SSIS using expression builder for Flat file connection Manager - ConnectionString.

Should be like: "Custom name" + "unique part" + "csv"

Actualy a timestamp in miliseconds would do.

Any idea?

Solution

  • I suggest you using the expression design to do that.

    Here Im using the ExecutionGuid to generate the value. It may not be the best idea because the result is quite big but you can use datetime functions as well to create something on the format you desire:

    enter image description here