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

[Former Member]

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

[former_member283908]

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

[dipalpatel]

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