Post reply

Is SSRS RDL maintenance dependent on the version of BIDS that created it?

  • March 17, 2014 at 10:14 am

    #305308

    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?

    BT

  • March 17, 2014 at 9:15 pm

    #1697838

    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?

    As a general rule, yes - you probably do need to stick with the same version of BIDS to maintain your reports. If you open a report in a later version, the RDL will be upgraded and you probably will not be able to open it with an earlier version of BIDS. You could also have problem deploying the upgraded report to an earlier version of SSRS (not 100% sure of that but it is quite likely).

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply