Modifying datasource of reports at one shot

[Pramod Jamadagni]

Hi,

Find the below link to identify the missing link for datasource.

http://ok-sandbox.com/2013/12/ssrs-fix-rsinvaliddatasourcereference/

 

Query to find the missing references to the datasource. Look for link column in the table “datasource”

 

-- Shared Data Source references with broken links

SELECT

  ItemPath = c.[Path],

  ItemName = c.Name,

  DatasourceRefrenceName=ds.Name

FROM

  [Catalog] AS c

  INNER JOIN DataSource AS ds ON ds.ItemID = c.ItemID

WHERE

  ds.Link IS NULL

  AND ds.Extension IS NULL

 

You can use update query something like below to do bulk reference assignment.

 

update DataSource SET link = '59D3C9B9-D8CA-4AB2-9EC8-EEDBC32EEC54' where itemid in ('147F7530-1CEE-4A97-BEAB-865B95011163'

,'0F0D6215-51F3-4A6F-8D4D-F6F1BA0B7C93')

 

 

Hope this helps,

Pramod.

[Chandrra]

thanks paramod. recently i started working on SSRS and i came across this issue. there were lot of challenge i had while creating reports. will post on our group when ever i get a chance.

thanks again keeping this tech group live.

--
You received this message because you are subscribed to the Google Groups "DWHTechies" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dwhtechies+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Thanks
Balachandra.S