Home Forums Reporting Services Reporting Services Is SSRS RDL maintenance dependent on the version of BIDS that created it? RE: Is SSRS RDL maintenance dependent on the version of BIDS that created it?

  • March 18, 2014 at 6:59 am

    #1697976

    Express12 (3/17/2014)

    I know this is true: To create or maintain an SSIS package, you must use the version of BIDS for that package. Eg. If an SSIS Pkg was developed in SQL 2005 BIDS, you must use SQL 2005 BIDS to maintain it. Optionally, you may convert/upgrade the SSIS Pkg to the version of SSDT or BIDS you have open.

    Is the same true for SSRS RDL? If I have a report developed in SSRS BIDS 2005, (outside of converting it to SQL 2012) do I need to use BIDS 2005 to maintain it?

    Yes, that is exactly true. You can upgrade your BIDS version to 2008, but you can't edit RDLs developed in SQL Server 2008 using BIDS 2005.