Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

FTP is not sending user define varible Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 1:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 31, 2014 8:49 PM
Points: 8, Visits: 79
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:\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. .
Post #1477348
Posted Thursday, July 25, 2013 9:19 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:52 PM
Points: 504, Visits: 1,870

Final:\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?
Post #1477565
Posted Thursday, July 25, 2013 9:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 25, 2014 3:39 AM
Points: 2, Visits: 49
I want time stamp should attached to file and that file should be send by FTP.
Post #1477838
Posted Friday, July 26, 2013 8:34 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:52 PM
Points: 504, Visits: 1,870
dineshvishe3 (7/25/2013)
I want time stamp should attached to file and that file should be send by FTP.


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.
Post #1478043
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse