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: 2993 times
Last Updated: Oct 27, 2009 at 01:35 PM
Transaction log error SSIS 2005
How do I output a query to a CSV file and attach to an email without having to save it?
SSIS issue in Vista 64 bit involving long lines inside the script component
SQL Running Total Query
Why does Bulk Insert block Update in SSIS?
Deadlock error when running SSIS package from SP
SSIS 2005 String Variable Limit
How to add custom xml tags like in web.config in dtsconfig of SSIS 2005?,How to store custom tags in dtsconfig file for SSIS package in MSSQL2005?
variable as expression in sql job
Loading data to different server using SSIS package