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)?
Sql-server – SQL Server 2008 R2 Standard with SSIS Enterprise
sql-server-2008-r2
Related Question
- Sql-server – Options for Data Encryption in SQL Server 2008 R2 Standard Edition
- Sql-server – SQL Server 2008 R2 Upgrade (Express to Standard) fails. No “Select Instance”
- Sql-server – Upgrading SQL Server 2008 R2 Standard edition to SQL Server 2008 R2 Enterprise edition what is the process and the impact
- Sql-server – SSIS Packages with SQL Server Express 2008 R2
- Sql-server – SQL Server 2008 Edition Upgrade Enterprise Evaluation to Standard problem
- Sql-server – Encrypted data using MS SQL SERVER 2008 R2 ENTERPRISE EDITION. Can we decrypt data using 2008 R2 STANDARD VERSION
- Sql-server – SQL Server 2008 R2 Standard Edition not using more than 32GB for BufferPool
Best Answer
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).