Pragmatic works have a SSIS unit testing feature built in to their Bi XPress product, but I have not tried it out so I can't tell you how good it...

You're trying to get a pig out of the mud. Not messy is likely not an option 🙂

And actually the first isn't messy at all, it is just...

However, the question seems to be worded incorrectly - if you run this code against SQL 2008R2 you only get two messages come back (At least I did when I...

Dynamically changing the formatting would be pretty tough as SSIS likes to validate the metadata.

Two easiest methods I can think of on top of my head:

1) Foreach loop that runs...

Your select list is actually pulling fields from the pivoted query, and you gave that query the alias "months", not vk.

Try "months.oppcode" or just "oppcode". Or to make it clearer,...

I don't know how you would get a server without the 64 bit utility unless its a 32 bit server. I believe the 64 bit installs by default, and...

More than 2 correct answers.

And the explanation of what is correct isn't even true.

Shiva says you get the syntax error because the table name is longer than a max table...

What is the output you are expecting?

Right, but does it still do that when you pass in the credentials instead of using integrated security?

On a logical level, I'd say the question was correct. You know the output of the inner query before the outer query because the inner query exists solely as a...

Hmm, a bit different than the situation I encountered then.

Does it work if you specify username (including domain) and password in the connection?

I am guessing that you are using Windows Authentication? Are you logged into the production server you are trying to run the package from, or are you connecting to...

In this case I believe it would be easier and better to include logic in your fact table about whether or not the facility was closed at the time of...

The date variable is fairly easy to work around I think. Instead of casting to that type, you cast to a string, substring off the time, cast back to a...

stub28 (7/17/2014)

---

Hi, could someone please assist a MDX novice with formatting the column values to "yyyy-MM" for the following MDX that runs and returns the Month Start Date as datetime...