Wrox Programmer Forums
|
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 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 October 10th, 2007, 12:15 AM
Registered User
 
Join Date: Oct 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default SSIS in ASP.Net 1.1

Hi Friends,

I have one problem.My application is in asp.net 1.1 and packages i made using sql server 2005 integration services.My DTS runs on every 20 minutes and now i want to know wheather currently it is running or not.How can i trace that???Do anybody have idea about it???
I have gone through logging also.I can check my DTS status from sysdtslog90 table but i cant know wheather DTS which is currently running is done successfully or it is failed ??
Please help me out..!! :(
Thanks in advance.


Falguni Joshi
 
Old October 10th, 2007, 05:28 AM
Wrox Author
 
Join Date: Sep 2007
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Falguni,

   If the package in question is logging to sysdtslog90, you can find currently running SSIS packages by executing a query that looks for 'Package Start' events without 'Package End' events grouped by ExecutionID and ordered by StartTime (descending). You can detect errors in this manner also, provided you are capturing package-level OnError events in your logging configuration.

Hope this helps,
Andy

Andy Leonard





Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET 3.5 answers in Professional ASP.NET 3.5 jminatel ASP.NET 3.5 Professionals 1 August 22nd, 2011 07:34 AM
Turning a regular ASP.NET App into an AJAX ASP.Net donrafeal7 Ajax 2 August 31st, 2007 12:33 AM
Execute SSIS Package from ASP.NET ghari ASP.NET 1.0 and 1.1 Professional 0 June 11th, 2007 12:51 AM
Slow loading ASP or SSIs hcweb Classic ASP Basics 7 October 8th, 2004 04:04 PM





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