So do you want the offices to run your DTS package on their server, or do you want your DTS package to send just the output to each office?

If it's...

Can't tell much from that one line. Maybe you could post the entire script?

Don't worry about querying the tables, load up the reports for Reporting Services, they're pretty cool.

The tool itself is still a beta release so I don't think you'll have much...

Are you using the same ODBC datasource, or the same destination tables? It could be that the second package is waiting for locks to be released from the first package.

Scheduled subscriptions are just SQL Agent jobs. You could just change the time on the jobs, but that may have other consequences within the RS database.

Another option would be to...

Returning any rows in Enterprise Manager is a drag. Before it displays any data, it has to format it into the grid.

Best to use Query Analyzer to return the data...

Also, it should be noted that Active/Active doesn't work if you're thinking of running the same application on each node. As noted above, each node should have it's own resources,...

The one big failure of using Outlook for sending alert messages is that if the Exchange server is unavailable, Outlook loses its connection.

Once that happens you can try using...

Take a look at my script here,

http://www.sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=606

This removes old versions of packages and their related logs. You can modify this to just remove the logs if you like. There is...

First, make sure you have enabled DTS Package Logging on the Package Properties page.

If you log to SQL Server, then the log information can be found in sysdtspackagelog, sysdtssteplog and...

Even better, use something similar to the earlier script to wipe out the packageID altogether. This ensures the package is loaded by name only. In which case the latest version...

Matt

You can assign your stored procedure output in a global variable rowset.

For more info on the rowset take a look at this article

http://www.sqldts.com/default.aspx?298

The DTS Import Wizard will try and create the database in the default directory.

The only way you can locate it elsewhere is to do as Greg suggested and create the...

The file will be located in the C:\Program Files...SQL Server\binn directory. That is where the DTS files are located.

Have you tried using the DTS FTP task?

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...