Post reply

Insight needed on SSIS file naming convention

  • February 1, 2016 at 8:00 am

    #399653

    Hi,

    So I currently have a SSIS package that generates an excel output to my local and then copies that out excel output("PED.XLS") to a network shared folder. My next task is to rename the excel output within the network shared folder with a new name and date stamp so the files are archived by dates.

    My question is, do I need another file system task, which would be set to rename the file, or can this process be done with the current copy file system task that I have already in place?

    What additional variables would I need to get this done?

    Below are my current variables:

    1)SourceFolderPath: C:\ETL\PED.XLS

    2)SourceDestinationPath:\\ab.Abc.org\share\Dept\CORP7\ABC\Reporting & Analysis\Reporting Extracts

    My desired output within the shared folder location would be "PED_Report.xls 20160201"

    Thanks in advance for any insight you may be able to offer.

  • February 1, 2016 at 8:30 am

    #1855699

    Move should let you do what you want including renaming the file.

  • February 1, 2016 at 8:56 am

    #1855720

    JustMarie (2/1/2016)

    Move should let you do what you want including renaming the file.

    Thank you for your reply, but I would like to retain a copy of the original excel output on my local, hence why I used the copy task.

  • February 1, 2016 at 9:30 am

    #1855730

    Briceston (2/1/2016)

    Hi,

    So I currently have a SSIS package that generates an excel output to my local and then copies that out excel output("PED.XLS") to a network shared folder. My next task is to rename the excel output within the network shared folder with a new name and date stamp so the files are archived by dates.

    My question is, do I need another file system task, which would be set to rename the file, or can this process be done with the current copy file system task that I have already in place?

    What additional variables would I need to get this done?

    Below are my current variables:

    1)SourceFolderPath: C:\ETL\PED.XLS

    2)SourceDestinationPath:\\ab.Abc.org\share\Dept\CORP7\ABC\Reporting & Analysis\Reporting Extracts

    My desired output within the shared folder location would be "PED_Report.xls 20160201"

    Thanks in advance for any insight you may be able to offer.

    The create file task will let you do only that. you'll need a task preceding the file creation to rename any existing file and append the date

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 1, 2016 at 10:09 am

    #1855746

    Perry Whittle (2/1/2016)

    Briceston (2/1/2016)

    Hi,

    So I currently have a SSIS package that generates an excel output to my local and then copies that out excel output("PED.XLS") to a network shared folder. My next task is to rename the excel output within the network shared folder with a new name and date stamp so the files are archived by dates.

    My question is, do I need another file system task, which would be set to rename the file, or can this process be done with the current copy file system task that I have already in place?

    What additional variables would I need to get this done?

    Below are my current variables:

    1)SourceFolderPath: C:\ETL\PED.XLS

    2)SourceDestinationPath:\\ab.Abc.org\share\Dept\CORP7\ABC\Reporting & Analysis\Reporting Extracts

    My desired output within the shared folder location would be "PED_Report.xls 20160201"

    Thanks in advance for any insight you may be able to offer.

    The create file task will let you do only that. you'll need a task preceding the file creation to rename any existing file and append the date

    Yes, I now understand this. My struggle is incorporating the correct logic for this.

Viewing 5 posts - 1 through 4 (of 4 total)

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