HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SQL Server 2008 R2 Standard with SSIS Enterprise

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
2008sqlwithssisstandardenterpriseserver

Problem

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

Solution

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 stored procedure, TVF, or .Net code embedded in the SSIS package (e.g. a script task).

Context

StackExchange Database Administrators Q#13145, answer score: 5

Revisions (0)

No revisions yet.