It means your database was once 134 GB big, but now it contains only for 10GB on data.

When data is deleted, space isn't automatically released. You can shrink your database...

I guess you are using SSIS?

Take the 2007 option, normally it should work.

Ssshhttt, I'm trying to brainwash here...

How did you set the default for MaxLoadMonth? Did you use a query?

Will the length ever be greater than 4000?

If not, you can just take DT_WSTR with a length of 4000.

Not great for package performance, but using a PIVOT isn't either 🙂

Maybe if you explain what you are trying to do?

To be completely correct: SQL Server 2008R2 needs .NET framework 3.5 sp1.

I'm not sure about the clients though.

Which environment are you working on?

A possibility is to use PivotTables in Excel, either based directly on the SQL relation engine, or on an SSAS cube or on a PowerPivot...

I don't think so.

That's because in SQL Server, we use set-based queries instead of cursors.

Cursors treat the data row by row, and are thus (usually) slower than set based manipulations.

Nice question to start the week.

ganeshkumar005 (8/24/2012)

---

for 'D1234', the first time it appears while reading from top, the value against it is 1001. I want this row in result. And skip the others if 'D1234'...

What are you doing exactly in the Lookup component? Why does it have to load staging as well?

A lookup component should be able to give you the inserts and the...

The easiest solution would be executing the stored procedure in the OLE DB Source, but not storing the results in a temp table but sending them to the dataflow. That...

shreenu.vasulu (8/23/2012)

---

Error Message is:

user does not have permission to alter the 'TestCube' object, or the object does not exist.

Open Services, go to Analysis services--->right click on it --> Properties-->LogOn -->...

Nice question, thanks.