Standard vs Enterprise Edition

• Lookup_BI

  Newbie

  Points: 0

  More actions

  November 20, 2007 at 12:47 pm

  #184323

  Hi,

  Anybody outhere can clear this out for me ?

  Is there any differences or impact on SSIS packages developed on SQL Server 2005 Enterprise and Standard Editions.

  My colleagues and me are in a debate over this.Futhermore there is a huge difference in the "$" figure on licensing.Seriously, do you see lesser options in SSIS Std Edition or is it more of a performance consideration.

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

• Andy Leonard

  Newbie

  Points: 0

  More actions

  November 21, 2007 at 4:45 am

  #753036

  Hi Jassmeet,

  As with a lot of SQL Server-related questions, the answer is (once again) "it depends".

  Here's a list of things you get with Enterprise that you do not get with Standard. Performance gains are realized by better parallel-processing support if the types of work you're doing with SSIS lends itself to parallelism.

  You get additional tasks in Enterprise: Data Mining, Fuzzy Lookup and Grouping, Term Extraction and Lookup, and SSAS connection adapters. There's another detailed list here.

  Hope this helps,

  Andy

  Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics