Hello.  I've been really stupid.  I've been looking at this for about 4 hours.  I've had another look after posting this and discovered that I have been deeply affected by...

I'm probably being stupid, but what is the best way to populate this list of Global Variables?  The data will be coming out of a database.

The current flow of data...

Erik,

thanks for the reply. 

Your above suggestion sounds very good.  I'll have to confirm that there are no security issues surrounding the Active X scripts, but it sounds the most...

After doing a bit more research, I see that SSIS is the replacement for DTS packages.  Does anyone know how hard it is to use SSIS to update specific cells...

Thanks for the feedback. 

The html to Excel sounds like a good idea.  Presumably you created the html file dynamically and populated the data as you reqruied them (?).  What...

Hi James,

thanks for the response.  Yeah, the real constraint is Excel.  It is just not a very good tool for database reporting (hence Crystal Reports and Reporting Services I guess).

I'll...

Not heard of this before I'm afraid.  You could try recreating them, or even writing the SQL that performs the same tasks.

What is the main job doing.  Try creating a...

Hi guys,

thanks for all the feedback.  Just to confirm that i'll be giving it a perf mon check later today...

wish me luck.

D

Thanks.  Will give it a go.

Are we the only organisation that has seen this I wonder...

Hum... Ta.

Hi KP Kumar.

I've done that and there is nothing running against it.  I know that sounds strange, but to confirm, I'm 100% there are no SPIDs running agains this DB. ...