question

gauravbaxi avatar image
gauravbaxi asked

Deploying SSIS 2008R2 package on SQL 2005

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
ssisbids
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

·
WilliamD avatar image
WilliamD answered
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.
1 comment
10 |1200

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

:( 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?
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.