I actually got this working for the most part. Selecting from the DDL causes a postback so in the page_load event I call a sub that changes the connection string,...

Thanks. I do that very thing in another web app that uses a couple of different frames. The actual SQLDATASOURCE is in the vb code so I can manipulate that....

Will do

One thing that we do to minimize network traffic is to do all processing on the DTS server The network traffic is then reduced to pulling data from the source,...

Yes

The...

I found it - it is for SQL 2008, though. If anyone is interested, it is called Slipstream Setup and here is a link to a very good explanation:

I use VBS for 2000 also but you need to use SMO on 2005/8 and that is what is in the post. One of the Dot Net languages or Powershell...

Actually, if you make the effort (good or not) to create a script and post it here, someone will help with it.

The snippet is part of a much larger program that scripts out every object in a database so it would be hard to break down.

Maybe someone who is good...

you can use one of the dot net languages with SMO to script the jobs. This is a snippet from something I did in VB.Net. Please keep in mind that...

You can delete or disabled them and the perf counter process will/should stop.

Anyone else get a shiver?

All it takes is one person looking over your shoulder and you could be in real deep. I hope one of those jobs wasn't "execute...

Another method would be to use VBA in Outlook. At one point, I wrote a couple of VBA macros that examined the Subject line of mail addressed to me and...

I second the motion !!!!:D

Microsoft puts out a monitoring freeware product call SQLH2. It is written in C# and the code comes with it so you can modify or add as you like. You...