To start with, you're passing "BuildingTypes" which is a string, not an object (i.e. a DataTable).

If anyone out there knows how to pass the "object" to code, please post.

As an...

Understanding performance in MSAS is quite a detailed topic. However, some things to get your started:

- How big is your cube and how do you have it partitioned? Partitioning the...

Add an ORDER BY to your SQL statement.

In general, you should never rely on embedded sort orders (i.e. view sorts, primary key of a table, etc.) to return the results...

Make sure you're running Integrated and SQL Login configurations.

It's been awhile since SQL 2000, but as I recall the default "sa" password should be blank. (Try logging in with user...

This post has opened up a really great set of dicsussions. To capture many on th points raised:

- Size always matters. Small generally means nimble and flexible. Large brings up...

I think he's just looking for a standard client / server set up.

First, to make the server automatically appear in the client side tools, you need to make sure you...

Basically, you should consider loading the data into Analysis Services. The key will be getting your dimensions correct. While there isn't space to go into all of the design elements,...

As already stated, SSIS has many methods to achieve what you're looking for. Alot of the specific recommendations depends on the data you're receiving and what you consider a duplicate...

Have to state some of the obvious points:

Does the file open / load in Excel? Any messages issuse there?

What version of Excel was the file created in? (Office 2007 is...

Michael is bang on. I'd like to add a small qualification:

Think hard about what you'd like the hiearchies to do / support. For example, based on your terms, I'd expect...

Actually, to scrub the records, It mighht be simpler to

Task 1

Import the whole record (no delimiters)

Split the record stream

Output to a temp file.

Task Two

...

Try the following:

REPLACE( [Column 0], "\\r\\l","" )

It would be helpful to get an idea of what you're attempting to do, but a suggestion:

Create your shared data source and the dataset you're looking for. Create a table...

Sarah,

You don't really need to go the activex route, although that's one way to go. Some suggestions:

- Rather than importing each file into a separate table, have you considered the...

To fully understand what Report Services is expecting for it's parameters, check out the properties/parameter tabe for a report that has a default value. You'll see the MDX encoding there...