I think the best takeaway from this is to learn from one's mistakes, chalk it up to experience, and become knowlegeable in the process of creating and storing backups, ie,...

No such thing as a mistake - its called deployment testing....

unable to locate the automation file mentioned in the article

You gave me two good ideas to try here. The first is the conversion of the sql statements into stored procedures. That will give me a good metric for sql...

Thanks for the quick response.

Currently I am using Exec SQL Task , with the SQLSourceType as direct input, SQLStatement with the actual T-SQL that gives me the recordset I want, for...

Hello,

These are the counters I am currently monitoring:

Performance Object: SQL Server:SSIS Pipeline

Buffer memory

Buffers in use

Buffers spooled

Flat buffer memory

Flat buffers in use

Private buffer memory

Private buffers in use

What can I monitor to...

What I was told by Microsoft Tech support when I ran into this problem was that SQL Server 2000 has a bug with this line:

Set xmlhttp = CreateObject("Msxml2.SERVERXMLHTTP")

It can create...