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?
Who is Participating?
PatrickK_WConnect With a Mentor Author 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
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?
PatrickK_WAuthor Commented:
no other answers - my solution was what I had to do to get it working.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.