Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I currently have SQL server 2008 R2 Standard installed with SSIS. I need a SSIS feature that is only available with the enterprise edition. Is it possible to upgrade SSIS only to enterprise while keeping the database install as is (standard)?

share|improve this question
    
You could install Developer Edition for pure development needs, but for production you need to fully upgrade you instance. SSIS itself is a feature of MS SQL Server (2k5 +), not an independent tool. –  Marian Feb 16 '12 at 12:49
add comment

migrated from stackoverflow.com Feb 15 '12 at 22:13

This question came from our site for professional and enthusiast programmers.

4 Answers

Like everyone has said, no, you can't upgrade SSIS to Enterprise and leave the rest as Standard, it doesn't work that way. If you can't implement the functionality another way like @concernedoftunbridgewells suggested, you could look at 3rd party tools to see if they can meet the need..like Attunity (fast Oracle data flow connections), Or Cozy ROC. They may be a bit cheaper than going for the Enterprise Lic. They also offer a lot of free SSIS tools. Good Luck.

share|improve this answer
add comment

No. The only way to license SSIS enterprise features is to get SQL Server Enterprise Edition. Your other option is to implement the functionality in some other way such as a sproc, TVF, or .Net code embedded in the SSIS package (e.g. a script task).

share|improve this answer
add comment

SSIS is included with SQL Server. If you need SSIS Enterprise, you need to purchase SQL Server Enterprise edition.

share|improve this answer
add comment

I am fairly certain that you will not be able to do that.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.