Skip to Content
0
Sep 18, 2012 at 07:10 AM

Moving Excel file from one location to another using Dataservices script

373 Views

Hi,

We are using Data services 4.0 sp2 , we are uploading flat file data in oracle database.

After the file upload we need to move that processed file to another location, so that next day user can put the new file at the same location.

I am not sure whether we can move the complete file using scripts in DS, but came to know that its possible to move the processed file to different location by using OS commands in SQL scripts.

So it is possible to move the file from one location to other ?

I am not expert at scripting , can i get a help that what script to be be wriiten to move the file from one location to other .

Regards,

Maruti