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?