Skip to Content
0

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

Sep 15, 2017 at 02:03 PM

62

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dipal Patel Oct 24, 2017 at 09:50 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Dorra KHEZAMI Oct 29, 2017 at 10:15 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded