SSIS Expression - get the next characters

155 views Asked by At

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?

0

There are 0 answers