# RsPackage

RsPackage is a tool to facilitate the automation of the deployment of reports, data sources and other artefacts to SQL Server Reporting Service (SSRS).

#How-to

Command line arguments

• -u or /url specifies the url of the target server for the deployment
• -f or /folder specifies the folder of the target server as the top-level folder for this deployment
• -s or /source specifies the path to the file containing the manifest for this deployment
• -r or /resources specifies the folder containing all the artefacts (rdl, rds and other files)
• -l or /logPath specifies the file where the log will be redirected. If missing logs are displayed in the console

Elements in the manifest of deployment

• <Project> is the top element of the manifest
• <Folder> lets you define a sub-folder and its content

<Folder Name="1">
   <Folder Name="1.1">
      <Folder Name="1.1.1">
      </Folder>
   </Folder>
   <Folder Name="1.2">
   </Folder>
</Folder>
<Folder Name="2">
   <Folder Name="2.1">
   </Folder>
</Folder>

• <Report> defines the name of the report and optionaly its filename (Element Path), description (Element Description) and visibility (attribute Hidden)

<Folder Name="1">
   <Report Name="My first report" Hidden="True">
      <Description>This is my first report to be published</Description>
      <Path>My1stReport.rdl</Path>
   </Report>
   <Report Name="My second report"/>
</Folder>

• <DataSource> defines the name of data source and optionaly its filename (Element Path), and preserve (attribute overwrite)

<DataSource Name="My data source" overwrite="false">
  <Path>MyDS.rds</Path>
</DataSource>

• <DataSet> defines the name of Shared Dataset and optionaly its filename (Element Path)

<DataSet Name="My datasets">
  <Path>MyDS.rsd<Path>
</DataSet>

• <Membership> defines the overload of a Role for the specific catalog item (and children). Additional members in the overloaded Role are specified in <Member> elements.

<Folder>
   <Membership Role="Browser">
      <Member>Domain\User1</Member>
      <Member>Domain\User2</Member>
    </Membership>
</Folder>