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