private ReportingServicesBatchUpload.ReportingServices2005WebService.DataSourceDefinition GetDataSourceFromRds(string rdsFilePath, out string name)
{
var dataSource = new ReportingServices2005WebService.DataSourceDefinition();
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
doc.Load(rdsFilePath);
int propertyCount = doc.SelectNodes("/RptDataSource/ConnectionProperties/*").Count;
if (propertyCount != 2 && propertyCount != 3)
Console.Error.WriteLine("Please check the rds file. There are an unexpected number of connection properties");
dataSource.Extension = doc.SelectSingleNode("/RptDataSource/ConnectionProperties/Extension").InnerText;
dataSource.ConnectString = doc.SelectSingleNode("/RptDataSource/ConnectionProperties/ConnectString").InnerText;
name = doc.SelectSingleNode("/RptDataSource/Name").InnerText;
return dataSource;
}