PatrickK_W
asked on
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?
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no other answers - my solution was what I had to do to get it working.