No it is not necessary to move that one.

No there are not.

@jim - I have updated the copy of the ssis package as the previous one was uploaded in error. You will need to create a new integration...

@smthembu sorry here is the create script

CREATE TABLE [dbo].[SSIS_Errors](

[Server] [varchar](128) NOT NULL,

[TaskName] [varchar](128) NULL,

[ErrorCode] [int] NULL,

[ErrorDescription] [varchar](max) NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Also, I have updated...

Jim,

I'm sorry I just now saw this post. Did you figure it out?

Kim

Yes parts of it. You can setup the SPROC, alert and job on each server you want to monitor. Then if you want to capture the data just...

@terry! If you are copying/pasting out of the article, yes, I do believe formatting did get messed up by the publisher. There is a .sql file at...

If you are copying/pasting out of the article, yes, I do believe formatting did get messed up by the publisher. There is a .sql file at the end of...

@ian - great addition! I will add this to my daily use. Thanks.

You could definately use the DMV for this info as well. I just like to have an alternative. I always set up a batch of reports for my...

I believe I said in my article that you can attach this to any alert you wanted, however good catch, i'll update my article.

Sorry, my bad! SQL Server 2008 R2 is what I have it running on.

Hi Jim,

Here is a word copy of my article and I added the instruction you asked for.

Thanks for the feed back everyone! Yes the logs are also a useful way to collect this information. The intention of this article is for an alternative collection...

I don't think this is my issue - no code breaks.