I need to get the exact file name of a txt file as the connection string of my flat file connection manager. I have used the following expression:
@[User::DataLoadDir]+"Myfile_" + (DT_STR, 4, 1252) YEAR (getdate()) + RIGHT ("0" + LTRIM ((DT_STR, 4, 1252) MONTH (getdate())), 2) + RIGHT ("0" + LTRIM ((DT_STR, 4, 1252) DAY (getdate())), 2) + ".TXT"
That returns
C:\Mypath\Myfile_20131203.TXT
But actually my filename has additionaldigits after the dates. It is
C:\Mypath\Myfile_20131203034537.TXT
What change should I do on my current expression? Is there something like putting * to indicate that it should accept any characters?