Skip to Content
avatar image
Former Member

How to Export file with dynamic name ( ex:- system date) from SAP BPC MS

Hi,

I need to create an automatic job to export files with unique names ( Ex:- system date_name). The job will run once every night. Essentially, I would like to have a package run, where it will title the exported .txt file as DDMMYY_Export, where the date will change, and the files will not overwrite prior day files.I can not see any option in data manager to do this until i am missing something. Can someone please help.

Thx

Sam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 24, 2017 at 09:50 PM

    Hi Sumit

    There might be an option to modify "Export" Data Manager package, which i do not know.

    The easy way to achieve your requirement is to modify filename after "Export" Data Manager package completes. You can use either Command scripts or SSIS package to do this and automate this task.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 29, 2017 at 10:15 AM

    Hi Sumit,

    As far as I know there is no standard feature in BPC MS packages to so this.

    You will need probably to create your own package SSIS (custom one) with visual studio.

    Regards

    Add comment
    10|10000 characters needed characters exceeded