SSIS Expressions Date Format get just YY for year 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 

DATAPART("yy",GETDATE())


but it gives me the same result as

DATAPART("yyyy",GETDATE())


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.
Use the modulo operator %: http://technet.microsoft.com/en-us/library/ms141815(v=sql.100).aspx

DATEPART("yyyy",GETDATE()) % 100


Your next problem may be that this will still be be a number and thus will not have leading zeros.

What is your underlying problem?  What are you trying to format a date as?

You would then just use (DT_WSTR, 2) DATEPART( "YY", GETDATE()) % 100 as part of your expression.