I have two packages in SSIS and I want to monitor the status of those through a web page. What is the best way to implement this.
Oct 19 '09 at 01:00 PM
Oct 27 '09 at 01:35 PM
I suggest you implement SSIS logging (built-in or custom) and monitor the log on the web page. Not the best solution, but you should be able to spin it up in short order.
Oct 19 '09 at 02:27 PM
Oct 27 '09 at 01:47 PM
If you are running the SSIS packages as SQL Agent Jobs you can query the history using msdn.dbo.sysjobs and msdb.dbo.sysjobhistory.
Oct 19 '09 at 04:33 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Oct 19 '09 at 01:00 PM
Seen: 1900 times
Last Updated: Oct 27 '09 at 01:35 PM
SSIS Connect failure
SSIS loading null/blank datetime values to SQL Table
How I can drill down an aggregate member?
DTS Package not executing on some machines
How is user variable added to Oracle sql expression used in SSIS variable
SSIS FTP File System Task
Loading data from one data source to another using SSIS Package
Using SSIS in SQL 2005 for Data warehousing
DTS wizard error 80040154 for SQL Server 2005 Express
passing data from csv to oledbsource sql command
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.