August 8, 2007 at 5:22 am
Dear forum,
How can i download an attachment from OWA to a directory with DTS SQL2000
The file is received once every morning through mail, though at different times and has the same name. How can i automate the processing of this file.
Should I use activeX, VB or is there a task within SQL2000 that can perform such step (automatic download from OWA and placing it in a designated directory).
Thanks,
Ben
August 9, 2007 at 9:01 am
Sounds like a two step process. 1. Download attachment xyz.txt from an e-mail from abc@company.com and place in \\dbserver\dtsinput directory, and 2. Once xyz.txt is found in the directory run DTSpkg1.
If the e-mail is coming in at non-specific time, then someone has to know it is there or an automated process should periodically check for it.
If the e-mail is coming to a monitored account, then set-up the rule on the full Outlook client to forward the message to \\dbserver\dtsinput. Add a scheduled task to dbserver to check for xyz.txt every 15 minutes and if found run DTSpkg1. On success, delete xyz.txt
If the account is not monitored, then a vbs with proper instructions can be set as a scheduled task on dbserver. Logically, every 15 minutes, query e-mail for message dated today from abc@company.com and if found, download attachment xyz.txt to \\dbserver\dtsinput. If success, delete/archive e-mail and run DTSpkg1. (This is dependent upon e-mail server settings if you can script download of messages and attachments, and if you can delete or move an e-mail using scripted calls, too.
Good luck.
August 10, 2007 at 4:30 am
I will look into it, thx for your suggestions.
Ben
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply