This is something I should know but for some reason the answer is eluding me. In a SSIS Script Task Editor, I am trying to set a package String variable called ReNameFile with the following VB.NET line using DateParts for month and year:
Dts.Variables("User::ReNameFile").Value = Dts.Variables("User::fileName").Value.ToString + DatePart(DateInterval.Month, Date.Now) + DatePart(DateInterval.Year, Date.Now) + ".csv"
This line is not working for me though and I think it's because I am messing up the concatenation of the dateparts. Can someone please guide me here?