Does Sql server2005 standard edition support Sql server integration services and SSRS

Does Sql server 2005 standard edition support Sql server integration services and SSRS. i saw two conflicting information.

And what is the difference between Integration services with basic transforms and integration services advanced transforms.

Please recommend.

Yes.

The following advanced transformations are available only in Enterprise edition related on SSIS:

Analysis Services Partition Processing Destination - with it you can perform incremental, full, or update processing of a AS partition.

Analysis Services Dimension Processing Destination for loading and processing a dimension.

Data Mining Training and Data Mining Query Component

Fuzzy Grouping, Fuzzy Lookup

Term Extraction and Term Lookup -used for "Text Mining"(Text Data Mining that work good for english texts)

So if you want to use SSIS package to process a cube, data mining structure and crossroad of bad data(Fuzzy Grouping, Fuzzy Lookup) you need Enterprise Edition.

|||

Can we use

SSIS
SSRS
ONLINE PROCESSING USING .NET
BATCH PROCESSING USING .NET

all in the same server. is there any performance issue related to standard 2005 vs enterprise 2005

Thanking you.

|||

In terms of comparing standard and enterprise on same machine , sure no, but you have limits on Standard:

-hardware level : max 4 CPU on server

-software level :NO partitioning, indexed views, and more

An article of this comparison

|||Thankyou