R.P.Rozema (1/12/2011)

---

Thanks for your responses. I managed to downgrade the packages. I need to thank a colleague -with great Google skills- for this, who sent me this link that references a little application SSISdowngrade on CodePlex[/url] doing most of the work downgrading a 2008 .dtsx package to 2005.

After running my packages through this application I could still not open the packages. So I opened up the packages in an xml editor and removed all references to system variable "System::ProductVersion", which apparently is not known in 2005. Plus I changed the connection string to my SQL database to use "SQLNCLI.1" for the Provider instead of "SQLNCLI10.1".

After doing this I could succesfully open the .dtsx files in Visual Studio 2005 / SQL server 2005. Only the encryption of the ftp password was still reported as an error, but that was easily solved by opening the package in Visual Studion 2005 and setting a new password.