ReportingService2010.SetDataSourceContents Method (String, DataSourceDefinition)
Applies To: SQL Server 2016 Preview
Sets the connection properties associated with a DataSource.
Assembly: ReportService2010 (in ReportService2010.dll)
The table below shows header and permissions information on this operation.
SOAP Header Usage
Native Mode Required Permissions
SharePoint Mode Required Permissions
To remove properties that are part of the data source definition, set the values of those properties to null (Nothing in Visual Basic).
If you set the CredentialRetrieval property of the data source definition to Integrated or Prompt, do not supply values for UserName or Password. Doing so causes a SOAP exception with the error code rsInvalidElementCombination.
With subscriptions, you may have to store credentials in the report server database so that the subscriptions can run unattended.
Setting the ConnectString property of the data source definition to null (Nothing in Visual Basic) causes a SOAP exception with the error code rsInvalidXML. If you do not want to supply a value for ConnectString, set its value to an empty string ("").
This method does not support changing Office Data Connections or files that have the .odc file name extension. Doing so causes an rsNotSupported error. For data sources with extensions other than .rsds or .odc, an rsWrongType error is returned.