I've achieved something similar to this using a table variable, sp_makewebtask and xp_smtp_sendmail.

The table variable holds the list of departments which are passed one at a time to sp_makewebtask which...

No need to even involve DTS or SQL.

Using VBScript, open two TextStream objects (one for input the other for output). Read a line from the input stream, write your first...

Check the Microsoft website. Can't recall the KB number at the moment, but there are specific instructions of what you need to do to allow SQL to communicate via TCP.

Use the inbuilt DTS FTP Task.

If you know the path to the file, you set it statically using Disconnected Edit, or dynamically using Dynamic Properties task.

Aaawww ... but I liked 'Steves beta test' []

1) Ugh ... I hate those ...

3) Try using WScript.Shell to just run the command without the %comspec%

But the error from the ExecSQL task will be in the package logging tables for you to query? Once you've extracted it you can act on it.

Also, do you know...

The script debugger is just that, a debugger for VBScript.

You can't debug anything other than VBScripts.

As much as it sounds, keep it simple and go for option 1.

Then you'll also have the option of manually re-running any of the individual packages.

If there is any hierarchy...

Checkout the following MSDN article.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp

Probably Example B is what you're after.

Nice article.

Only thing I would change is using a permanent table instead of a temporary one.

Then you can accumulate the data and perform some analysis on it.

Steve mentioned "I typically don't review the scripts when they are submitted because honestly I don't have time". I'm sure this is true of the other site owners as well.

Would...

What do you mean by "only use one data provider", I've got a couple of reports that reference different databases both in SQL Server and Progress via ODBC.

One report in...

Instead or querying sysindexes and INFORMATION_SCHEMA, check Books Online for the DBCC SHOWCONTIG command. It has an option called TABLERESULTS which return the information in table form.

EG:

CREATE TABLE #Fraglist (

ObjectName...

SQL 2000 doesn't have a date datatype, you'll have to wait for SQL Server 2005 for that.

When you insert the date into a datetime field it will automatically add 00:00:00...