SSIS - Dynamic File Name for FTP Component
===

I'm trying to create a data flow in SSIS to help me upload a file via FTP and I'm having a bit of trouble. The name of the file needs to be dynamic, in the format of filename_mmddyy.xls. So every day it applies the date and uploads a new file.

I was able to make it so that the file would save correctly in a data flow with the following expression:

    @[User::path]+ 
    Right("0"+(DT_STR,4,1252)DatePart("m",getdate()),2)+
    Right("0"+(DT_STR,4,1252)DatePart("d",getdate()),2)+
    Right("0"+(DT_STR,4,1252)DatePart("yyyy",getdate()),2)+
    ".xls"

The FTP component, however, won't take this as an expression for the LocalPath. I tried to overwrite my User::path variable inside of a Script Component in my original data flow, but that didn't seem to work either. 

I know I'm missing something every simple, but I've stared at it long enough and it's just not coming to me.

Thanks!