November 15, 2010 at 8:42 am
I have 2 instances of SQL Server on the same virtual server. One is SQL Server 2005 and the other was just upgraded from SQL Server 2000 to SQL Server 2008. This is a development server and there were existing SSIS packages on the SQL Server 2005 instance. However, since there is only one version of Intergration Services, 2008, that is running on the server, I am getting the following error when jobs are attempting to run the 2005 versions of SSIS Packages:
Description: The task "Script Task" cannot run on this edition of Integration Services. It requires a higher level edition.
I need to maintain both the 2005 and 2008 versions of SQL Server on my development server, since we have not yet upgraded production to SQL Server 2008.
We have already discovered that there is no backward compatibility for SQL Server 2008 SSIS packages that will allow them to run on a SQL Server 2005 instance.
How can I run these SQL Server 2005 SSIS packages with the 2008 version of Integration Services, without upgrading the packages?
November 15, 2010 at 11:48 am
I think it is not possible without upgrading your packages.
Or you should shut down your SSIS 2008 instance, start your 2005 instance and run your 2005 packages. And vice versa to run 2008 packages.
Welcome to the world of not so backwards compatibility!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply