I have an SSIS solution where depending on a parameter, it launches the extraction of different databases, each in a different file, and the name must contain the date of the extraction so we can't hard code the name in the Destination wizard, I must use a variable where I concatenate the date to a file name, and I have to use that variable as the file name.
What I have tried:
I crateated this variable : "C:\\Users\\Nemos\\Desktop\\H\\T\\INC\\Contrats_INC" +"_" + (DT_WSTR, 06) @[User::VMois_EXEC] +"_VD" +".csv"
In the propreties of my file i added an expression as a connection string and i droped my varaiable.
Still won't work