Hello,
I've built a basic ETL ssis package that drops an Excel file from on network share to another network share. I've been asked to append the month and year to the file name as MMM-yyyy (i.e. Apr-2018). I've been able to write it as 04-2018 but haven't been able to figure out the code/syntax for it to show as Apr-2018. Below is the code I wrote, and please advise what I have to do for my solution to work.
"ReportName- " + Right("0" + (DT_WSTR,2)MONTH(GETDATE()), 2) + " " + (DT_WSTR,4)YEAR(GETDATE()) + ".xlsx"
There is no elegant way of doing this, but it can be done longhand. Check this link for an example.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.