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’…


BizTalk Server Architecture – Cluster and BizTalk Groups on the same servers

I am  currently working on a BizTalk project for a big customer in the healthcare area. When I joined the team, the BizTalk environments, up to the production system, where already up and running. It was a relative simple architecture with 2 BizTalk Nodes working in a group and a SQL Failover Cluster serving as…


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…


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…


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…


SSIS – programmatically add an aggregate component

Intro In this part of my series of blogs about dynamically modifying SSIS Packages I describe how to programmatically add or modify an Aggregate component. Sample The following code snippet shows how to add and modify an aggregate component by implementing the following steps 1. Add a new aggregate component to a data flow tasks.2….


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…


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…


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…


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…