February 26, 2010 at 9:41 am
I am trying to deploy SQL Server 2005 SSIS packages using an SSISDeploymentManifest file (via Package Installation wizard).
The deployment is on a Windows 2008 dev server with SQL Server 2008 only, but it failed with the following error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
I have seen different articles with the same problem, but they assume you have SQL 2005 installled:
http://dojothemouse.livejournal.com/269864.html
Can anyone provide a solution to the problem (with SQL Server 2008 being the only DB)?
February 26, 2010 at 8:10 pm
You may have to have SQL Server 2005 installed on a Server to do this but please check out the following links:
Installing (sql server 2005) SSIS packages on SQL Server 2008?
So you're trying to deploy a SQL Server Integration Services package to a 2005 server, but you recently installed SQL Server 2008? Not behaving nicely?
http://dojothemouse.livejournal.com/269864.html
Unable to import/save SISS packages
More fun with SSIS deployment
http://dojothemouse.livejournal.com/269864.html
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply