Post reply

SSIS FTP Takes Collect & Email

  • January 23, 2009 at 3:05 am

    #130328

    Scenario

    I have an FTP task that:

    1. Copys a file from an FTP site to a local folder

    2. Emails the file

    Problem

    The file name in my current Scenario is static and will always be called 'New File'.

    BUT, the scope has now changed and the file will be called

    "Todaysfile_TODAYSDATE[/u]"

    Where TODAYSDATE will be in the format of 20090109

    Therefore the file name will be "TodaysFile_20090109"

    How can I get the SSIS package to search for this file on a day to day basis?

    Thanks

  • January 23, 2009 at 4:21 am

    #931714

    Please any ideas would be helpful!

  • January 23, 2009 at 8:23 am

    #931816

    Hi,

    You can use an expression in your ftp task to dynamically build the remote path, and replace the value of the property.

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

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