locked
Standalone SSIS Standard Edition RRS feed

  • Question

  • Hello,

    I've an understanding that the standalone installation of SSIS standard edition 2005 can work without any issue with standalone sql server 2005 enterprise edition and sql server 2005 standard edition.

    Please let me know if there is any correction need for this understanding.

    Thanks

    Sandip
    Tuesday, October 13, 2009 7:25 AM

Answers

  • Hello,

    I've an understanding that the standalone installation of SSIS standard edition 2005 can work without any issue with standalone sql server 2005 enterprise edition and sql server 2005 standard edition.

    Please let me know if there is any correction need for this understanding.

    Thanks

    Sandip

    SSIS can work independently of SQL Server, there is no requirement to have SQL Server isntalled. Note that a few features of SSIS (e.g. Notably Fuzzy Lookup and Fuzzy Grouping) DO have a dependancy on SSIS but if you don't use them you won't have any trouble.

    -Jamie

    http://sqlblog.com/blogs/jamie_thomson/ | http://jamiethomson.spaces.live.com/ | @jamiet
    • Marked as answer by Sandip Maniar Tuesday, October 13, 2009 8:05 AM
    Tuesday, October 13, 2009 8:01 AM

All replies

  • Hello,

    I've an understanding that the standalone installation of SSIS standard edition 2005 can work without any issue with standalone sql server 2005 enterprise edition and sql server 2005 standard edition.

    Please let me know if there is any correction need for this understanding.

    Thanks

    Sandip

    SSIS can work independently of SQL Server, there is no requirement to have SQL Server isntalled. Note that a few features of SSIS (e.g. Notably Fuzzy Lookup and Fuzzy Grouping) DO have a dependancy on SSIS but if you don't use them you won't have any trouble.

    -Jamie

    http://sqlblog.com/blogs/jamie_thomson/ | http://jamiethomson.spaces.live.com/ | @jamiet
    • Marked as answer by Sandip Maniar Tuesday, October 13, 2009 8:05 AM
    Tuesday, October 13, 2009 8:01 AM
  • Hi sandip,
    You are correct.

    There are no feature limitations or artificial governors within Standard compared to Enterprise. The same control flow and data flow engines underpin both editions, with the same configuration and deployment options allowing you to work seamlessly between environments and editions if using the common components.

    The advanced transforms only available with Enterprise edition:

    • Data Mining Training Destination
    • Data Mining Query Component
    • Fuzzy Grouping
    • Fuzzy Lookup
    • Term Extraction
    • Term Lookup
    • Dimension Processing Destination
    • Partition Processing Destination
    The advanced tasks only available with Enterprise edition:
    • Data Mining Query Task

    If you need the above features you have to go for enterprise edition.

    Thank You.

    Please Vote & "Mark As Answer" if this post is helpful to you.

    Cheers
    Bikash Dash
    MCDBA/MCITP

    Tuesday, October 13, 2009 8:03 AM
  • Bikash,
    I don't think he was asking about the difference between the standard and enterprise editions of SSIS.

    http://sqlblog.com/blogs/jamie_thomson/ | http://jamiethomson.spaces.live.com/ | @jamiet
    Tuesday, October 13, 2009 8:51 AM