November 20, 2007 at 12:47 pm
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]
November 21, 2007 at 4:45 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply