Jeff Moden (7/1/2014)

---

Just to be clear, it's not a file. It's a table. And, sorry but I have to ask, how does the simple existence of a table...

No, Steve is right. You won't be able to access the cube unless it has been successfully processed.

Regards

Lempster

Did you update statistics when you upgraded? I'm betting that you didn't. Run a manual UPDATE STATISTICS against the table(s) in question and see if the query performance improves.

Regards

Lempster

reddychaitanyakrishna (6/27/2014)

---

Yes you can do it using Shared Data Source..... by creating the connection for the first time....and for every 2nd report just give the Shared data source.....

That's it...

Not that I am aware of.

Perry Whittle (6/26/2014)

---

What's so difficult about...

Your current approach will work fine in SSIS 2012 regardless of the deployment model.

Regards

Lempster

You are not mistaken Koen, but you don't get that option if you choose...

You can build an empty cube and then add dimensions later, but usually, yes, you would create your cube from an existing Data Source View (DSV) and use existing dimensions...

Have a look at this post. It doesn't pinpoint the issue or explain how to resolve it, but gives some pointers where to look.

Regards

Lempster

I don't think you can do this in a single Execute SQL task, but you could you an Execute SQL task with Result set to 'Full Result Set' and store...

Do you mean why something changed from a business perspective or from a logical perspective? Using Lookup and Conditional Split transforms it's quite easy to track whether column values have...

Are you running that command in a command prompt window or are you using it in a SQL...

Rename the configuration table and see which packages fail when executed! 😉

Evil Kraig F (6/18/2014)

If you stage data from your SSIS components (flatfiles/excel/etc) it's usually so you can do final passes on the data for aggregation and/or sorting (where SSIS fails,...