Sending Data Access Project Reports using DTS

[CanNeverThinkOfaName]

is it possible???

I need to send out reports via email to teams . The Attachement on these emails are reports I have created in the Data access project and I need to send the exact format.

Is there any way to do this automatically via the DTS- I know I can do it via a macro but that's no good to me as the macro has no way of knowing when the DTS has finished running so it can send the emails...

Any suggestions are REALLY WELCOME!!!!!

Thanks
maria

 

[HRoarke]

In the DTS Designer, there is a DTSSendMail task which enables you to create and send an e-mail message with an attachment. Using it from the designer (as opposed to, for example, modifying it via the VB DTSPackage object library) will require that your attachments have the same name and are in the same location on each execution. Simply add a precedent that requires your prior steps be completed successfully before this task is executed and you're there!

<bw>
"I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine."
— John Galt
Atlas Shrugged

If you want to get the best response to a question, please check out FAQ222-2244 first

 

[CanNeverThinkOfaName]

I've tried this already but the problem is is that the reports are only stored in the data access project under 'Reports' When you search for which mail attachements to attach it only finds the data access project and not the actual report...

Do you understand what I mean?SQL doesn't recognise Data Access Project Reports and Macros....