A cursor is a construct in TSQL to iterate over data:

DECLARE CURSOR (Transact-SQL)

A table is obviously used to store data and it can be a "physical object", but you can...

Too bad there aren't any interviews with the other candidates.

First you check which account is used to run the SSAS service. (you can do this in the SQL Server Configuration Manager)

Then you log into the database server and check...

Either make sure the service account has read permissions on the database, or use another account for impersonation.

Normally no, because the load happens in a transaction.

It depends a bit on the settings of the OLE DB Destination. You might want to lower the batch size to try...

I don't think you can.

Prior to processing a cube (which is necessary to view the data), it is deployed to the server.

You could install SSAS locally though.

If there is an...

You can say that about almost any tool 😉 😀

happycat59 (9/30/2013)

---

If you are using the stored proc to lookup a value and return that to your SSIS package, you can do this using an output variable in the stored...

Nice question. Never even heard about it, made me do some research.

No problem, glad to help 🙂

You're not designing windows forms, you are designing SSIS packages.

Right click on project, go to properties, go to debugging and set Run64BitRuntime to false.

No problem, glad to help.

I don't see a reason why not.

Personally I would keep the 2008R2 developer instead of Express, but that's just a personal view.

OK, what if you copy the .mdf file to the DATA folder of your SQL Server installation and try it again?

Screenshot?