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.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
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 '09 at 01:00 PM
Seen: 2235 times
Last Updated: Oct 27 '09 at 01:35 PM
What is best way to copy a Solution to a new name?
Converting VARCHAR value to SMALLDATETIME in SQL 2005 (SSIS)
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
Prerequisite to run dtexec.exe from the command line?
Configuring Sql Server 2005 Integration Services for High Availability
SSIS loading null/blank datetime values to SQL Table
Processing XML from web by SSIS 2005
DTS Package not executing on some machines