Hi
Have used DTS wizard before but now have to use DTS Designer for first time and need some assistance. I have a number of SQL updates that I have setup as Execute SQL Tasks. What I am trying to achieve is to output the number of records affected by the various updates to maybe a global variable and then the last step of the DTS package is to email the results to an email group. I will continue to worj out but if anyone can offer help/ideas would be much appreciated. Thanks

In your Proc you could pass out the number of rows affected as Output
parameters

You can then use this article to extract them into Global Variables

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/Default.aspx?234)


You can then use the object model to assign them to the body of your eMail

Changing the DTS Send Mail Task
(http://www.sqldts.com/default.aspx?235)


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Dazza" <Dazza (AT) discussions (DOT) microsoft.com> wrote

setup as Execute SQL Tasks. What I am trying to achieve is to output the
number of records affected by the various updates to maybe a global variable
and then the last step of the DTS package is to email the results to an
email group. I will continue to worj out but if anyone can offer help/ideas
would be much appreciated. Thanks