|
Hi Friends, 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. Thanks, Gaurav
(comments are locked)
|
|
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. :( Thanks for the reply. While looking for the answers I came through this link which says that it downgrades the SSIS: http://ssisctc.codeplex.com/wikipage?title=SSIS%20Downgrade I am going to try it now. Is there anyone else who has gone through the same situation and found a way out?
Sep 11 '12 at 06:59 AM
gauravbaxi
(comments are locked)
|
