edit SSIS from BIDS 2005 in BIDS for 2012

Hi, I have rebuilt my machine recently and added VS 2013 and SQL Server 2014 client tools and BIDS.

Unfortunalty I have a number of SSIS packages running on a customers SQL Server 2005 server that I need to edit. I cannot install SLQ Server 2005 BIDS on my machine as it says there is a later version installed (there is).

If I load the project ane edit the packages in VS 2013/BIDS for SQL Server 204 I can no longer run them on SQL Server 2005.

is there a way of targeting the DTSX packages at 2005 instead of the latest version so that I can edit them?
LVL 1
PatrickK_WAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Not sure it's wise supporting a 2005 32-bit application on an obviously 64-bit box, especially with the different flavors of connections and drivers.  Is keeping a 2005 32-bit box around to support this client an option?
0
PatrickK_WAuthor Commented:
The only way to get this working was uninstall all the SQL Server client tools, then install 2005, 2012 and 2014 in order.

Now working fine
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatrickK_WAuthor Commented:
no other answers - my solution was what I had to do to get it working.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.