Mailing a Manifest

Question

Mailing a Manifest

Jonah-178744

Valued Member

Points: 50
More actions
February 8, 2006 at 8:57 am

#166843

Im currently involved in a Label project in where an Order is raised and jobs on this order are picked, once the job is raised though the user has the option to print off certain labels which are then stuck on a box for the carrier. At the end of the day a manifest will be produced for all the labels produced for each box.
The way it works now is that a manifest is printed off and then given to the driver who collects the goods from us.
We want to email the manifest at the end of day to the carrier so that we will cut out the paperwork plus the reliabilty of the driver picking up the document.
The manifest is scheduled to appear in a drive on a server.
Would it be possible to get SQL Server to pick up this manifest file and mail it to the relevant people? (This would have to be a scheduled pick up of the file).
Your help would be much appreciated.

Thank You...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Microsoft has an "Add On" of Notification services, perhaps you could write some code to extend it and do this.

Generally I avoid emailing things externally (Out of the network domain) from sql server. I would store the document out on a file server, and create an email log table, and have a service pick it up at your scheduled time, Compose the email and send it out from a webserver.

Jonah-178744 Valued Member Points: 50 More actions · Answer 2

'Generally I avoid emailing things externally (Out of the network domain) from sql server'. Why is this Ray, do u find it unreliable? Also, the manifest will be scheduled to run at the end of day, this file will be saved to a file server. Im really looking to use DTS to mail this manifest out. My programming is not that up to scratch and i need to get this done by Friday. Any suggestions??

Thank you

Ray M SSC-Insane Points: 21093 More actions · Answer 3

No because you'll have to open a port in the firewall which will expose your sql server to the world.

Justyna Mr or Mrs. 500 Points: 594 More actions · Answer 4

I would use a DTS and I would select the 'Send Mail' task if you have it available. Then I would select the file to add as an attachment and schedule the DTS to run at a certain time of the day as a job.

J