Final:-D:\test20130724_230456_662000000.xls which having expression
"D:\\test"+Replace(Replace(Replace(Replace((DT_WSTR,50)(getdate()),"-","")," ","_"),":",""),".","_")+".xls"
But [Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: The filename, directory name, or volume label syntax is incorrect. .
A couple of questions.
1. Is 'test' the directory or part of the file name?
2. Have you looked at getdate() in your expression for the file name? It will generate a new file name every time it's evaluated. Is that what you want?