Setting up a dts package to run an access report.

  • I'm not sure if this is possible, but will give it a shot.

    Is their a way to define a DTS package that can e-mail three reports that are defined inside an ADP Access Project?

  • You can create SQL TASK with SMPT MAIL that can send emails with reports ZIPPED.

    http://www.sqldev.net/xp/xpsmtp.htm

    I hope this helps

  • When utilizing the SQL Task, how can I define a query that knows how to grab these three reports inside the access adp project?

    I'm a little confused on how that would work?

Viewing 3 posts - 1 through 2 (of 2 total)

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