x

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

gauravbaxi gravatar image

gauravbaxi
21 1 1 1

(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

WilliamD gravatar image

WilliamD
25.9k 17 19 41

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x927
x35

asked: Sep 11, 2012 at 05:51 AM

Seen: 985 times

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