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)?
Tell me more
×
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.
|
migrated from stackoverflow.com Feb 15 '12 at 22:13
|
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. |
|||
|
|
|
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). |
||||
|
|
|
SSIS is included with SQL Server. If you need SSIS Enterprise, you need to purchase SQL Server Enterprise edition. |
|||
|
|
|
I am fairly certain that you will not be able to do that. |
|||
|
|
