Command: GetShrDS        

 

set shared data source information

 

SSRS Version:

 

2000, 2005 (N), 2005 (I), 2008 (N), 2008 (I),2008r2(N), 2008r2(I), 2012(N), 2012(I), Azure

 

(N)=Native

(I)=Integrated

 

Syntax

 

Sets a shared dataset. This can be used with a report or folder

 

SetShrDS  shared dataset|Folder /DS:Datasource [/N:Name] [/S]

SetShrDS  [/?] displays help

 

   /N:     If not specified 'DataSetDataSource' is used

   /DS:   Data source name

   /S     Only valid with folder, will recurse sub folders too

 

 

    

 

Parameters

 

[/S]   Include Sub folders

 

 

 

Examples

 

Set the shared dataset \dataset\ds1 to link to data source \data sources\datasource1

 

SetShrDS \dataset\ds1 ds:"\data sources\datasource1"

 

 

 

Set all shared datasets in the folder \dataset to link to data source \data sources\datasource1

 

SetShrDS \dataset ds:"\data sources\datasource1"

 

 

Set all shared datasets in the folder and sub folder \dataset to link to data source \data sources\datasource1

 

SetShrDS \dataset ds:"\data sources\datasource1" /s

 

 

Remarks

 

•You must choose either a shared data source or a folder. Both are mutually exclusive.

•Enclose folder / shared dataset if there are spaces in the name.

 

 

See Also

 

CreateShrDS        -        Create Shared dataset

GetShrDS        -        Get shared dataset information

SetShrDS                -        Set shared dataset link to data source