Post reply

RemoteVariable

  • 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!!!

  • 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"

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply