FTP is not sending user define varible

• sqldbaonly

  SSC Veteran

  Points: 216

  More actions

  July 25, 2013 at 1:03 am

  #280949

  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. .

• kl25

  Hall of Fame

  Points: 3752

  More actions

  July 25, 2013 at 9:19 am

  #1635778

  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?

• dineshvishe3

  SSC-Addicted

  Points: 464

  More actions

  July 25, 2013 at 9:14 pm

  #1636018

  I want time stamp should attached to file and that file should be send by FTP.

• kl25

  Hall of Fame

  Points: 3752

  More actions

  July 26, 2013 at 8:34 am

  #1636188

  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.