on 08-04-2015 6:47 AM
Hi Gurus,
We have an requirement where the source system will sending the attachment of flat-file through the mail.
where we need to build a job based on that flat-file.
Expected volume of data
1 file daily average of 45 orders
Periodicity
Monday to Friday
Schedule
9-12:00 hrs.
Is there any way to automate this process before the job run.
Regards,
Akhilesh Kiran.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Akhilesh,
You can run a VB Script and send the attachment before the job is started
Please refer to my document
You can execute the VB script through a btach command which will only send the file to the ETL team for processing
Regards
Arun Sasi
That doesn't sounds to be a reasonable way to receive data for loading.
Ideally, flat file should be sent to shared folder/FTP from where BODS job can easily pick it.
Try working on alternatives.
Can you give info about the mail server.
Sandeep
Hi
We didn't received anything about the mail server details as of now.
But in the REQUIREMENTS ANALYSIS document they mentioned.
Means of connection
Email
Target system
PFS
Area
Orders
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.