Data Services Script to move excel file

[#1]

Hi All,

I'm new to Data Services and need some help in creating a script that will sit at the end of a workflow which will move an excel file (.xls) from one folder location to an archive folder. The file move needs to complete so that when the workflow is executed the following day, the dataflow before the script picks up the new file (hence the wildcard * in the file name)

exec('cmd.exe','Move \\FAS2050N1\Groups\Reports\Business Intelligence\Excel Based Feeds\AACC\Warehouse Feed\Daily CDN Export*.xls \\FAS2050N1\Groups\Reports\Business Intelligence\Excel Based Feeds\AACC\Warehouse Feed\Archive',1);

The workflow validates and executes but I get error 50306.

I don't want to go down the route of creating a .bat file on the server

Kind Regards
Wardie

[Former Member]

try this

exec('cmd','Move \\FAS2050N1\Groups\Reports\Business Intelligence\Excel Based Feeds\AACC\Warehouse Feed\Daily CDN Export*.xls \\FAS2050N1\Groups\Reports\Business Intelligence\Excel Based Feeds\AACC\Warehouse Feed\Archive');

Thanks

Murali

[Former Member]

Thanks for the input Murali put unfortunately your suggestion didn't work.

The exec function requires a Flag integer at the end of the statement. I've also tried the Flag integer 8 which does validate and states that its run successfully but it hasn't moved the file at all. The Flag integer 8 basically overrides an error code if ones occurred or not