SSIS_QES

[dileep kumar]

Hai Sir,
I have to send the data to a flat files as destinations
but i want the date at the end of the flat file name how we can do
that

For ex:- sample.txt but i need sample20120516.txt

can u suggest me a right way to that

Thanks,
Dileep.

[Sridar Krishnamoorthy]

1.Store ur file name in variable1
2.create variable2
3.variable2 = concatenate(variable1, getdate)
4.use variable2 as your destination filename.

Try and let me know

Sent from my iPhone