Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1393165-1549-1.aspx

In 2013 I will be exploring the new BI capabilities in SQL Server and Office 2013 (so basically the tabular model and PowerView).

I hope to get my MCSE certification on...

Usually integer columns are a bit faster than string columns.

So for a primary key it's a good idea to take an integer column, instead of a string column or a...

I would put a property on the visibility of the 2012 column that checks the parameter value.

Put a dataflow on the control flow. Add an OLE DB source and an OLE DB Destination. Done.

(you can find stuff like this in even the most basic tutorial on...

I don't see any actual errors. What does the SQL Server Agent log say?

Yes, if you have a link between those two.

In other words, one dimension should have a foreign key to the other dimension.

Nice easy question, thanks!

In SSRS...

If you don't specify the package to run in 32-bit it will run in 64-bit and thus search for 64-bit providers.

So I think you won't need the 32-bit provider on...

dan-572483 (12/4/2012)

---

I would say anthing with at least 12GB of RAM. That way you can run VMs for a domain controller and two cluster nodes without having to...

You'll need two dimensions in your cube. One SendCountry dimension (linked to the fact with the SndCountryKey) and one PayCountry dimension (linked to the fact table with the PayCountryKey)

This modelling...

It seems to be some sort of permission issue.

Which account is used to run the SSIS package?

Does DB2 have some sort of bulk insert functionality?

Could you be a bit more specific?

What do you want to improve?