I think you may be referring to a feature of Toad for SQL Server, developed by Quest software.

There are versions of Toad for Oracle, MySQL and SQL Server (and maybe...

One way

Pass the whole MDX as a string, embedding the parameters

="SELECT NON EMPTY { [Measures].[Land Area Controlled] } ON COLUMNS, NON EMPTY CROSSJOIN ( {" & Join(Parameters!Developer.Value,",") &"}, {DESCENDANTS( [Location].[Country].["...

Your FROM clause requires a cube, not a query.

You should be supplying the parameterized dimension to either a row, a column or as a contraint

Not quite sure what you mean.

Proclarity was purchased by Microsoft and has effectively been superceded by PerformancePoint Server. I'm not sure you can even still buy Proclarity, which is a...

??

what issue

My thoughts are that if you are being asked for a report that contains 100 columns, you can bet that someone somewhere is doing a hell of a lot of...

Hmmm... Well this forum is for SQL 2005.... Since when is DTS part of SQL 2005 Business Intelligence ? Try posting in a DTS forum 😉

As with most things SSIS, there's more than one way (probably) to skin this cat 😉

Here's something that worked for me though:

1. Flat File Source

The key here is to set...

brukewilliam (8/27/2008)

---

I just had a chance to look into SQL Server Reporting Services. We had a debate on what to pick, Crystal Reports or SQL Server Reporting Services. With a...

What error message do you get?

Number of ways you could do this, if I understand you correctly.

One way might be to create the two separate data flows and use a precedence constraint to determine which...

😀

I have previously just installed .Net - I didn't need to uninstall BIDS.

I think that BIDS is effectively .Net with reduced functionality, so effectively all you are doing is an...

You develop SSIS packages within Visual Studio / BIDS (Business Intelligence Development Studio)

So you need to open either of those 2 programs and under new project, select integration services package...

When you set up SSIS package configurations, you get an option to either specify the configuration settings directly or to store them in an enivironment variable.