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

Useful partition script

Retrieve filegroup by table name and partition range The following script can be used to retrieve the filegroup name for a given table and a partition range.  It can be very useful in an automated sliding window process. declare @tablename nvarchar(128) declare @range sql_variant   set @tablename = ‚myPartitionedTable‘ set @range = 1209   declare…

2

ETL Checklist

The content of this article is based on the experience I gained in a big data warehouse project. My initial intent writing this article is to provide a good starting point for other DWH projects where one have to design and build ETL processes. In the first chapter I am writing about the data sources…

1

Delete BizTalk Artifacts within C#

When you are developing and testing BizTalk projects, one of the most common tasks is to cleanup BizTalk server from suspended items, running service instances and so on. A commonly used method achieve this is to use the following powershell script: Import-module “C:\Program Files (x86)\Microsoft BizTalk Server 2013 R2\SDK\Utilities\PowerShell\BizTalkFactory.PowerShell.Extensions.dll” Get-ChildItem –Path ‘BizTalk:\Health and Activity\Service Instances’…

1

Recursive delete procedure

The following procedure can be used in development systems to remove data from tables which are referenced by other tables. The procedure recursively follows all the references and deletes all referening tables first. Be careful, when you use it! All data of all referenced tables will be deleted. create procedure temp.RecursiveDelete(     @tablename nvarchar(1000)     ,@schemaname nvarchar(1000))as…

1

Programmatically add or modify a FlatFile-Source component

Intro   In the first article of this series I painted the high level picture and provided an overview of the package generation framework. In this and the following articles I want to show how to programmatically generate or modify specific SSIS components. FlatFile Source Component The first step is to find the connection manager…

1

Windows Phone 7 – Dynamically load XAML

Sometimes it is necessary to load an element like a shape dynamically from an file, resource or directly from a string into the corresponding API classes. In Silverlight for Windows Phone 7 this can be done with the use of the XamlReader Class. This class can be found in the System.Windows.Markup namespace. With the use…

0

Move an ASP.NET application to the cloud

 This is a step by step guide to move an existing ASP.NET Web Application to the Cloud.  Add a cloud service project to your existing solution Solution Explorer right click your solution and select ‘Add -> New project …’ In the Add New Project dialog select Installed Templates –> Cloud -> Windows Azure Project template…

0

SSIS – Programmatically connect DataFlow components

In this part of my series of blogs about dynamically modifying SSIS Packages I describe how to use the SSIS programming API to create and connect data flow components. DataFlow Components have input or/and output column collections depending on the type of component. Components like DataSources do not have an input collection whilst destination component…

0