Click here to Skip to main content
15,889,843 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a package that run's on weekly basis.. I need to move file from main folder to archive folder on FTP server.

so how to create expression for below files name:-
ABC.FSR_Satrtdate20200131_date20200221
ABC.FSR_Satrtdate20200124_date20200214
ABC.FSR_Satrtdate20200117_date20200207
ABC.FSR_Satrtdate20200103_date20200124

What I have tried:

I tried to build the expression like @[User::FileName]+Replace(Substring((DT_WSTR,30)GETDATE() ,1,10)),"-","")+"_date"+Replace(Substring((DT_WSTR,30)GETDATE() -7,1,10),"-","")+".txt"

but getting error. Any help would be really Helpful.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900