Let's say we do need Month Name and Day Name in our SSIS Package later to create archive files with Day Name or Month Name, or we need to Send in Email or simply we have to load this information with data to a table.
SSIS does not provide Month Name or Day Name built in functions. I have a post for SSIS 2008, where I created variables and wrote expressions on them to get Month Name and Day Name, Click Here .
In our this demo, we will be using Expression Tasks to populate the Values of DayName and MonthName variables at start of SSIS Packages.
Let's create an SSIS Package with two Variables DayName and MonthName as shown below.
Bring Expression Tasks to the Control Flow and change the name of it to "Set DayName Variable". Double Click on it and write expression as shown below