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

more ▼

asked Sep 11, 2012 at 05:51 AM in Default

avatar image

21 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Sep 11, 2012 at 06:23 AM

avatar image

26.2k 18 37 48

:( 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, 2012 at 06:59 AM gauravbaxi
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 11, 2012 at 05:51 AM

Seen: 1235 times

Last Updated: Sep 11, 2012 at 07:02 AM

Copyright 2018 Redgate Software. Privacy Policy