HI All,

I have developed SSIS Packages in SQL 2008 BIDS. Now when im trying to open the project in SQL 2005 BIDS , it is throwing up errors due to version issue.

Does anybody know how to run the SQL 2008 BIDS project on a system having only SQL 2005?(Like is there any compatibility pack or something etc)

Any help in this regards will be appreciated


Thanks in Advance


Rakesh

It is not possible. BIDS 2008 projects are not downgradeable to 2005.

If you're an expert in XML, and havea lot of time on your hands, you may be able to directly view 2005 and 2008 package XML, determine the differences that make a 2008 package different from a 2005 package, then edit the 2008 package's XML directly to downgrade it. I wish you luck.

---

It is not possible. BIDS 2008 projects are not downgradeable to 2005.

If you're an expert in XML, and havea lot of time on your hands, you may be able to directly view 2005 and 2008 package XML, determine the differences that make a 2008 package different from a 2005 package, then edit the 2008 package's XML directly to downgrade it. I wish you luck.

---