Normally you can install different editions side by side without issues.

Which datatype is used in the dataflow?

Go to the advanced editor of the source component and check the output columns.

Display Database Image using MS SQL Server 2008 Reporting Services

Is it possible to give the desired output for the sample data that you provided?

Something like this?

SELECT ID, Name, Type, CountType = COUNT(Type)

FROM Table1 t1 INNER JOIN Table2 t2 ON t1.Type = t2.Type

GROUP BY ID, Name, Type

This code is a best guess, as there's...

It's possible. You can "model" a dimensional starschema in the data source view of Analysis Services.

Which data column did you want to remove exactly?

And which column do you want to speed up?

Typically, indexes will enhance query performance, if created correctly.

Easy one for Monday, thanks!

ps: not meant sarcastic, ironicallly or cynically, but as a real compliment. Just in case 🙂

Jeff Moden (7/27/2012)

Wow... Another eye opener that...

Jeff Moden (7/27/2012)

BWAAA_HAAA!!!! Too funny, Koen! I think that even without your "ps", I'd have picked up on the irony of...

Nice question, thanks.

Jeff, this is all your fault.

http://www.sqlservercentral.com/Forums/Topic1336367-147-1.aspx#bm1336413

ps: irony

Forget SSIS and use the bcp utility.

You just need to upgrade the package to the 2008 SSIS version (it will change a version number in the XML behind the .dtsx and upgrade the native providers) Since...