Post reply

SSRS: getting rdl from [ReportServer].[dbo].[Catalog]. file trancated.

  • August 29, 2014 at 11:24 am

    #298960

    Hi,

    I tried to get all rdl's from ReportServer db for full inventory using super script from Vinay Pugalia(c). and could not get complete xml, it broken/truncated I'm not sure why.

    in each case it's on different length so I assume it's not a max length problem, did anybody tried to do this?

    select LEN(Contx) FROM (

    SELECT TOP 1 CONVERT(VARCHAR(MAX), CASE WHEN LEFT(C.Content,3) = 0xEFBBBF THEN STUFF(C.Content,1,3,'''')

    ELSE C.Content END) Contx

    FROM [ReportServer].[dbo].[Catalog] CL

    CROSS APPLY (SELECT CONVERT(VARBINARY(MAX),CL.Content) Content) C WHERE CL.[Type] = 2

    )B

    Thanks

    Mario

  • August 29, 2014 at 11:33 am

    #1741994

    Have you tried using an export column task in SSIS to do this? I use this approach to export all of my stored SSIS packages in MSDB, should work similarly for reports.

  • August 29, 2014 at 11:36 am

    #1741996

    Hi, Star

    No I never tried to use IS, on the end I need to store thetm as file with bcp

    Tx

    M

  • August 29, 2014 at 11:38 am

    #1741997

    I have a package that exports all my SSIS packages as dtsx files into a particular file share controlled by a variable. I would think you could use the same approach here pretty easily.

    PM me if you want the code....

  • August 29, 2014 at 2:08 pm

    #1742025

    Tx all. moving it to SSRS Section

Viewing 5 posts - 1 through 4 (of 4 total)

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