For databases of this size, I'd be setting up custom maintenance routines. Using the maintenance plans is ok for smaller databases, but their all-or-nothing approach can lead to long maintenance...

I'd try to setup a web page to execute a scheduled job that runs the package. Nothing to install on the client machine then. One less thing to worry about...

The best setup would be to have IIS and SQLRS on one box, but only have the RS databases hosted on that box. Having your main databases off on another...

So is the display of the period data a formatting requirement, or do you get an error when you extract the data?

In Excel, if you need to display any non-text...

Sounds about right.

Let me know how you get on.

This is where having the ability to post an image would be most helpful.

First, check the properties of each of the workflows and make sure they reference the correct tasks....

I'd attack this from a different angle. One DTS package that loops through gathering the data and emailing the file for each user.

One of the first tasks in the DTS...

You can output the results to an Excel file easily enough. If you're not too worried about the layout of the information, export the results to a tab-delimited text file...

Are you sure you're running the correct version of the package?

Do you have any tasks in the package that are not in the workflow?

Are there any scripts within the package...

Progress doesn't have any limits on character data when the field is accessed using Progress 4GL. When you access the same field using SQL-92 ODBC driver it uses a property...

The performance collector needs to run under a profile setup for US dates.

"28/10/2004 10:03:49 Status: Perf records loaded: 0"

This line indicates that no records were...

Yes, the scheduled task should include the /D option.

You'll need to run the PerformanceCollector service under an account that is setup for US dates (MS are working on fixing this)....

The image doesn't show up, is it hosted on a publicly accesible server?

Anyway, two workflows to one task will always work as an AND operation. You can bypass that by...

Auto-Layout in DTS - the most hated button I've ever come across

Unfortunately, removing that little button would probably result in crippling the...

Using seperate packages can be very useful. It allows a greater flexibility in whats run and when. It can also be much easier to track down problems.

Alternatively, if you're stuck...