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, 2009 at 01:00 PM
Oct 27, 2009 at 01:35 PM
Tom Staab ♦
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, 2009 at 02:27 PM
Oct 27, 2009 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, 2009 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
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Oct 19, 2009 at 01:00 PM
Seen: 3111 times
Last Updated: Oct 27, 2009 at 01:35 PM
SSIS -FTP connection file watcher
Dynamic Excel Source file in SSIS using Variable - can't get it working
How is user variable added to Oracle sql expression used in SSIS variable
how to join tables from two server
How do I output a query to a CSV file and attach to an email without having to save it?
SSIS Connection Manager / Config Theory
SSIS issue in Vista 64 bit involving long lines inside the script component
SSIS loading null/blank datetime values to SQL Table
Archiving complete tables
Processing XML from web by SSIS 2005