Accessing MS Reporting Services with Java

In this article I describe how to access Microsoft Reporting Services Web Service interface with a Java web service client. Microsoft Reporting Services MS Reporting Services (MSRS) provides its full functionality via two Web services endpoints. The WSDL for the endpoints are accessed using the following URL’s: http://<Server Name>/ReportServer/ReportService2005.asmx?wsdlhttp://<Server Name>/ReportServer/ReportExecution2005.asmx?wsdl The first on is the…


Creating SSIS Packages dynamically from template packages

Scenario In data warehouse projects it is often necessary to import a huge amount of data provided in CSV format into a database, without making essential structural changes to the source data format.   Possible requirements for this Extract Transform Load (ETL) processes are: –       Adding a BatchId to the imported records in the staging…

8