I wrote this script to document the connection properties. You could use it as a base to modify the properties.

http://www.sqlserver.org.au/resources/ViewResource.aspx?resourceId=40

Leif

Without any idea of your environment or setup I'd take a stab at saying that the report you built returned zero rows due to Report Builders implicit use of inner...

The big chore I've come across with Report Builder is translating all the database fields into recognisable form for end users eg: only after a few years working with this database, I've...

Good pointers Andy, stress is one of the much hidden killers

Haven't tried it myself (all of our Excel reports are single pagers), but what about putting the headers in the page header section? Of course any dynamic text in the fields...

Are you running the latest service pack for Reporting Services?

Prior to SP1 the file format was MIME Encapsulation of Aggregate HTML (MHTML), which could only be opened in Excel 2002...

Tracy

In the report design, have you selected the option to repeat the headers on each page?

You can't use the local system account as that account doesn't have any privelages for remote resources.

We have SQLH2 gathering info from a dozen or so servers, not all of...

Nice short article, but probably a little too short and definately needs some screenshots. Maybe after "a couple hours", a extra couple of hours should have been spent making everything presentable.

The...

My take is that it's entirely up to if you want spend an hour every morning looking through jobs in Enterprise manager. If you're not putting anything else on hold while...

The problem with that suggestion is that, as per my original post, it's not always the same table.

Last night this same table loaded without any problems, but another much larger...

Do you have package logging turned on? You might get additional error details that way.

I've also used this task and haven't had any problems.

Just followed steps as outline on the...

The 'On Error Resume Next' statement basically causes the error to be ignored.

Without that statement the script will abort on the line that causes the error. This is undesirable as...

Ahhh ... I feel your pain. We're also dealing with extracting gigabytes worth of data from an external vendors system.

At least you have date fields to limit your data transfer....

Following standard ETL practices, load your data into a staging table the use multiple ExecuteSQL tasks to execute your stored procedures in required order. This will allow you to process...