Syd2008
asked on
DTS email Notification
Hi Expert,
I have a DTS Package with Access as a Datasource which contains 6 execute SQL tasks (update lot of tables in access database).
I want to setup my DTS package in such a way that after it executed all the tasks it will send me an email with a text file based on the DTS package result which contains all the counts of updated rows by running set of querys example : select count(*) from table_name where file_name like date()
can you please advice me how should I proceed with this task.
any ideas will appriciate
Thank you
I have a DTS Package with Access as a Datasource which contains 6 execute SQL tasks (update lot of tables in access database).
I want to setup my DTS package in such a way that after it executed all the tasks it will send me an email with a text file based on the DTS package result which contains all the counts of updated rows by running set of querys example : select count(*) from table_name where file_name like date()
can you please advice me how should I proceed with this task.
any ideas will appriciate
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes I think you can use that if you sql server is configured to use SQL Mail. Give it a go...
I only gave blt solution since thats how i implemented it in our business and we don have sql mail configured on the sql server.
I only gave blt solution since thats how i implemented it in our business and we don have sql mail configured on the sql server.
ASKER
instead of using blat , cant we use send email task as our last task in my DTS package and attach that to a text file.
and that text file is generated based on the DTS result (a set of result queries run against the database after executing the package)
what do you think ?