edit SSIS from BIDS 2005 in BIDS for 2012
Posted on 2014-12-19
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?