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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

migrated from Feb 15 '12 at 22:13

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

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

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

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

share|improve this answer

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

share|improve this answer

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 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

Your Answer


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