question

TatyanaY avatar image
TatyanaY asked

Storing packages in earlier versions is not supported

I see that this question was posted earlier, and even marked as answered, but I don't think there was any solution offered... I have an SSIS package in the Visual Studio 2008. I downloaded it from the server with the SQL server version 2005. Now, when I'm trying to save copy of this package back to the same instance of Integration Services, I am getting this 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." Is there any workaround for this problem?
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Shawn_Melton avatar image
Shawn_Melton answered
In order to deploy an SSIS package it requires the compatible version of BIDS. - BIDS 2005 (Visual Studio 2005) = SQL Server 2005 - BIDS 2008 (Visual Studio 2008) = SQL Server 2008 So if you are working in BIDS 2008 on a SQL Server 2005 instance, you cannot save or redeploy the package unless you do it through BIDS 2005.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I understand. I just thought it might be possible to replace a thing or two in the package code. Like, Version=9.0.242.0 instead of Version=10.0.0.0 . But it looks like there are too many things to change? So, the only solution still would be to recreate the package in VS 2005?
0 Likes 0 ·
I have never heard anyone being able modify the XML in order to force it.
0 Likes 0 ·
OK. Thank you!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.