Friday, February 20, 2009

Feature Consideration for SQL Server / SSIS project estimation

I'm reading: Feature Consideration for SQL Server / SSIS project estimationTweet this !
In an SSIS project, before starting low-level implementation or design, one thing that needs to be put on the checklist is the feature-list available in the procured/to-be procured version of SQL Server vs the actual implementation requirements.

Express, WorkGroup, Web Edition for SQL Server 2005 were almost not equipped at all with SSIS. With SQL Server 2008 Express, Express Advanced, WorkGroup and Web edition, Micorosoft has demonstrated some generosity and these editions now contain some basic SSIS capabilites.

Standard Edition contains BI studio and restricted set of transformation and tasks. So don't be under the impression that if you have the standard edition, you have entire SSIS capabilites at your disposal. Still I would say that many mid-scale projects would suffice with the set of features available with the standard version.

For summary, the tasks / transforms that are available only with Enterprise Edition of SQL Server 2005 / 2008 in general are as mentioned below:
  • Data Mining Training Destination
  • Data Mining Query Component
  • Fuzzy Grouping
  • Fuzzy Lookup
  • Term Extraction
  • Term Lookup
  • Dimension Processing Destination
  • Partition Processing Destination
  • Data Mining Query Task

Refer to the links below for a full list of feature set supported by SQL Server 2005 and SQL Server 2008.

SQL Server 2005 Features Comparison by Editions

SQL Server 2008 Features Comparison by Editions

3 comments:

scottieworld said...

cool stuff do yo have any cool seo techniques

Anonymous said...

Very Informative Blog!!!

Good stuff on SSIS


Regards
Sam

Siddharth said...

I just try to keep my blog rich with contextual and orginial content, rather than re-publishing content from other blogs. Add meta tags to the blog to make the search engine aware of the context, and keep updating the blog. This is only what I do with my blog :)

Related Posts with Thumbnails