July 25, 2013 at 1:03 am
I am using SSIS package.
FTP Task Editor=>
IsLocalPathVarible:- True
Local Varible :- User::Final
Operation :Send Files
ISTransferASCII :- False
Remote Parameter
IsRemotePathVarible :-False
REmote Path :- \Location
OverwriteFileAtDest :- YES
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. .
July 25, 2013 at 9:19 am
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?
July 25, 2013 at 9:14 pm
I want time stamp should attached to file and that file should be send by FTP.
July 26, 2013 at 8:34 am
dineshvishe3 (7/25/2013)
Is it possible that there is a lag between when the file is created and when your variable is populated? If so, the file names would be different leading to an error.
[Edit] Just realized that the statement above was not from the original poster. Not sure if the comment relates to the OP's issue or if this is a different request.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply