Thank you. I found the problem and there was a typo in the table name.

Thanks for the suggestions. I have reduced the size about as much as I can to get any form of meaningful result (e.g. 1 of 23 sites and 1...

Jason,

Thanks for your response. I am a newbie using MDX for retrieving data and I hope to answer your questions:

The amount of data retrieved is approx. 40,000 rows and...

Thanks for your help. I tried this and it works well.

Thank you. I have found a way to build an MDX query to get most of what I want and have put it in an SSIS package as you...

Thanks for the help. The source of the report is a SSRS from a data cube. I am new to anything to do with MDX and have attempted...

Thanks to all. the resolution I came up with was to create a backup device that pointed to the network location and backed up the database to the backup...

Thanks to all. I modified to run in parallel and all is well. As informtion, the individual packages are the same at the source (SQL Server tables ...

Thanks. I think you may have given me the solution with your question. I had the packages running in serial vs. parallel. I will change that and...

Sorry,

I should have been more specific in description. The question relates to building queries in SQLMS. A brief sample of a query would be:

Select

[DateInactive],

[Inactive]

The brackets around the fields...

Thanks to all for your suggestions. I have tried it and it works perfectly as I was pretty sure it would.

Howard

I agree with all of Brandie's comments. The key to me is the move from a "desktop" to a "PC" vs. to a "server". The reasons for such...

I don't believe you would need separate files for a DB that size. You may wnat to consider SQL 2008 vs. 2005 if you need to use SSRS. ...

Thanks to all. I have tried this and it works fine. Actually this is potentially more than a one of, but the overhead to address this at the...

Forgot to include the actual query that may have helped.

Select

TIU_DOCUMENT_8925,

IEN,

REPORT_TEXT,

LEN(REPORT_TEXT) as length

From Vista2.dbo.TIU_ReportText0

Where TIU_DOCUMENT_8925 = 20556116

and IEN in (29,36)

--

The result has the last column as the calculated length...