I found many articles on date formatting expressions in SSIS but I couldn't find one that specified how to get just the Year such as 13 for 2013 or 12 for 2012... I tried
but it gives me the same result as
I was thinking of a dirty/hack fix which would be something like
DATAPART("yyyy",GETDATE()) - 2000
but it just doesn't feel right.... what if someone runs my package 1000 years from now? lol. Any suggestions?
I am trying to add a time stamp to a file name.. so today's file should be Auth040113.txt. I am creating the file name in a variable using expressions.