Have Geek Brain

Best way to start a nightly process that manages data and sends email through SQL Server 2005

I have an asp application that is running SQL Server 2005 and I would like to start processes that:

  • request data,
  • manipulate data and
  • send emails containing specific data and analysis.

What's the easiest way to do this in SQL Server 2005? Can I do this in an SSIS package? Should I use CLR procedures?

+1


a source to share


4 answers


You can do it with SSIS package, or better yet, with TSQL alone.



Can you give us more details if you need more help / ideas?

+2


a source


Perhaps you could come across this use case with Jobs inside SQL Server 2005 (Standard or Higher) and just execute the query stored procedures. What data and based on what parameters do you need to request?

And what manipulations do you need to do? You can use SQL Server Mail to send results.



This way, you would be completely independent of your ASP application for these tasks.

+1


a source


As others have stated, you can achieve this using SQL Server Integration Services or a combination of SQL Server Jobs and Stored Procedures.

Personally, I suggest you take a look at the SSIS route, as existing existing component tasks will provide a significant portion of the functionality you need out of the box, thereby speeding up the development process.

If you want a smart report and deliver results that look truly professional, you can define a SQL Server Reporting Services report and call it from SSIS.

0


a source


Depending on how complex they are, just go with T-SQL stored procedures including using xp_send_dbmail to send an email, then schedule it with a SQL Agent job.

0


a source






More articles:


All Articles