We have a SSIS package which is developed using BIDS in SQL 2008R2. We are stuck in a problem that the client machine where we have to use/deploy this SSIS package has SQL 2005. Is it possible to deploy and execute a SQL 2008R2 package in SQL 2005? If yes, please let me know how. If No, please let me know what are the alternates so that we do not have to develop the package again in SQL 2005.
asked Sep 11, 2012 at 05:51 AM in Default
Unfortunately I know of no other option than to re-develop the package using BIDS 2005. As far as I know there is no tool to convert from 2008 back to 2005. I think BIDS offers an upgrade ability to go from 2005 to 2008, just not the other way.
answered Sep 11, 2012 at 06:23 AM