RemoteVariable

• A Little Help Please

  SSCarpal Tunnel

  Points: 4764

  More actions

  January 23, 2009 at 9:35 am

  #133735

  Im trying to fetch a file which will always include the current date.

  Within FTP Task Editor I have set the 'IsRemotePathVariable' to 'True'

  In 'Add Variable' i have selected Value Type to be 'String'

  and i have put the following in the value field...

  "trial_bal_by_currency_11_SOD_1_LON_" + (DT_WSTR, 4) YEAR( GETDATE() + (DT_WSTR, 2)MONTH( GETDATE() + (DT_WSTR, 2) DAY( GETDATE() + ".pdf"

  THIS DOES NOT WORK!

  File will look file 'trial_bal_by_currency_11_SOD_1_LON_20090123.pdf"

  PLEASE HELP!!!

• Mukti

  SSCrazy

  Points: 2746

  More actions

  January 23, 2009 at 1:02 pm

  #932007

  Try the following expression:

  "trial_bal_by_currency_11_SOD_1_LON_" + (DT_WSTR, 4) DATEPART( "yyyy", getdate() )

  + RIGHT("00" + (DT_WSTR, 2) DATEPART( "mm", getdate() ),2) +

  RIGHT("00" + (DT_WSTR, 2) DATEPART( "dd", getdate() ),2) + ".pdf"

• A Little Help Please

  SSCarpal Tunnel

  Points: 4764

  More actions

  January 26, 2009 at 12:17 am

  #932470

  Thanks but this does not work either.

  Within FTP Task Editor:

  - "IsRemotePathVariable" Set to "True"

  - "RemoteVariable" set to

  NameSpace: user

  Value type: String

  Value: "trial_bal_by_currency_11_SOD_1_LON_" + (DT_WSTR, 4) DATEPART( "yyyy", getdate() ) + RIGHT("00" + (DT_WSTR, 2)

  DATEPART( "mm", getdate() ),2) + RIGHT("00" + (DT_WSTR, 2) DATEPART( "dd", getdate() ),2) + ".pdf"

  Error: 0xC002F304 at FTP Task, FTP Task:

  An error occurred with the following error message: "Illegal characters in path.".