In Part 1 we discussed that in development environemnt we deploy reports by simply clicking “Deploy” in BIDS, but this won’t work in production. To deploy reports in production we need to write an SSRS script, which is actually a piece of VB.NET code executing against SSRS web service.
A typical report consists of the report definition (the
.rdl file) that references one or more data sources. And this is where things get tricky.
Deploying Data Sources
You create a data source using a call to rs.CreateDataSource() method. Unfortunately, this method does not accept
.rds files that BIDS uses to store data source information. Instead it wants a DataSourceDefinition object. This means that one must parse the
.rds file and convert it to a
DataSourceDefinition instance. Here’s a piece of code that does that. It is geared for datasources with integrated credentials, if you use other kind of credentials, you’ll need to make relevant modifications.
Dim doc As System.Xml.XmlDocument = New System.Xml.XmlDocument
Dim dataSource As DataSourceDefinition = New DataSourceDefinition
dataSource.ConnectString = doc.SelectSingleNode("/RptDataSource/ConnectionProperties/ConnectString/text()").Value
dataSource.Extension = doc.SelectSingleNode("/RptDataSource/ConnectionProperties/Extension/text()").Value
dataSource.CredentialRetrieval = CredentialRetrievalEnum.Integrated
dataSource.Enabled = True
dataSource.EnabledSpecified = True
Dim name As String
name = doc.SelectSingleNode("/RptDataSource/Name/text()").Value
Dim overwrite As Boolean = false
rs.CreateDataSource(name, "/Data Sources", overwrite, dataSource, Nothing)
This was easy, wasn’t it? Full version of the code with logging and error handling can be found here.
But data sources are only one half of the story. In Part 3 we will discuss how to deploy reports.