I did try to write to the c drive and that failed as well. Maybe the account did not have permissions to write to the c drive on the server....

I have never seen a way of setting the time in sql server. If anyone has a way I would love to see it. I would approach the problem by...

Thanks Darrell, but my code is OK - I think.

----------------------------------------------------------------

Function Main()

          ' Initiate variables

          Dim appExcel

          Dim newBook

          Dim oSheet

          Dim path

          Dim oPackage

          Dim oConn

          ' Set...

Another idea would be to create a table that holds the data for the chart through a dts job. Run it every Sunday night for example.

Hook an excel chart onto...

I had a similar issue once and I found that there is no real way of speeding up the query through the index.

If you select * from the table concerned...

I take it that you are using activex script to transform the data before populating the text file. If so, use :

Replace(String, FindSubstring, ReplaceSubstring, Start, Count, Compare)

For you...

I can almost gurantee that you are running a maintenance job which contains a rebuild of indexes. This always increases the log excessively.

You need to set up a good indexing...

Are you using oracle on NT. My last job had a similar problem when trying to run reports for more than an hour. Funnily enough, it bombed out at exactly...

The #temp table is only available to the session that it is created in. You can create the properties of the dts task dynamically using a dynamic properties task, but...

Try out microsoft web components; They're free as well.

http://www.microsoft.com/downloads/details.aspx?FamilyID=982b0359-0a86-4fb2-a7ee-5f3a499515dd&displaylang=en

There are so many BI packages out there at the moment that you really need to be careful when choosing. I can't say that I have used factbroker before, but...

I can only see three ways of skipping the rows without using a temporary table.

1. Use an activex script on the transformation skipping the duplicate rows with 'Main =...

Thanks for the advice. I have instaled office now but will remember this for next time.

Thanks. It works a treat.

I managed to get me hands on a book at about the same time I read this and it was in there also.

Thanks again.

A very good question that I myself have been loking into.

Unfortunately, apart from analysis services all the other products out there are new and a very specialised.

You must also...