Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 22nd, 2004, 03:43 AM
Authorized User
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP & DTS in SQL server

hello people!
i am working on a customer care project with ASP (VB script) as the front end & MS SQL server as the back end
the description follows:

i am getting complaints from users which i will assign to engineers
i want to start a countdown timer on hitting a button based on the priority....
ie. i set the level of a particular record & press the save button....
if the level is 1, then a countdown timer of 15 minutes should be started & when the timer reaches 0,
an email should be generated & sent to me & another user that i will specify.
for level 2, timer should be 45 minutes & for level 3, it should be 180 minutes
how would this be done???

i want the provision for being able to run multiple timers concurrently

About the email notification, every 'complaint' is given a priority level and based upon it the engineer is supposed to fix
the problem. What i want is that once the prescribed time for a given 'complaint' expires,
an email is sent from the server end (sql server) to the relevant people,
in this case it should be sent to the coordinator (who forwards the complaint to an engineer)
and the user who logged in the complaint.How i figured this would work was by implementing a countdown timer for
every priority level, at the timeout of which the email is triggered by the server, automatically.
What i havent been able to figure out is how to implement the timer and connect it to the email trigger
or even if its going to work like that at all. Could someone please help me in this and also if someone could please tell me
what exactly needs to be done to set up an email service e.g what email component to use, how to configure it etc.

now i tried posting this topic in the ASP forum where i was suggested to use a DTS for the above
i am not sure how a DTS works & i tried to look it up on the net but didnt get anything useful.....
can someone please help me?
i am racing against time and all help in this matter would be greatly appreciated.!!!

Old March 22nd, 2004, 09:23 AM
planoie's Avatar
Friend of Wrox
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts

Please don't cross post.


Similar Threads
Thread Thread Starter Forum Replies Last Post
asp.net & sql server database naeem.net ASP.NET 2.0 Professional 13 July 18th, 2007 02:10 PM
ASP.NET 2.0 & SQL Server 2000 / 2005 Hosting NonStopMark ASP.NET 2.0 Basics 1 January 1st, 2007 02:56 AM
ASP.Net & SQL Server chenwf2006 ASP.NET 2.0 Basics 0 December 17th, 2006 03:54 AM
ASP.NET & SQL Server 2K Stored Procedure kwilliams ASP.NET 2.0 Basics 7 May 10th, 2006 12:55 AM
ASP & DTS in SQL server a_pathak SQL Server ASP 2 March 24th, 2004 12:48 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.