Select Page

Run as Different User

As a consultant I often need to run a program as a different user. For future reference I collected the information about RunAs in this article. In Windows 7 en Windows Server 2008R2 you can run an application as a different user  by holding down the shift key and...

Create a LightSwitch Application to Maintain Metadata

Correct metadata is essential for every automation solution. When I started working with BIML I used one table that describes the source to target table mapping. (see the “Creating a Meta Data Driven SSIS Solution with BIML” series) And that works fine in most simple...

Making your Biml files less complex

The combination of XML and C# code in a Biml file can make Biml files very complex. In web development Microsoft overcame this problem by introducing the code-behind model with one file for the static (html) text and a separate file for the dynamic code. Unfortunately...

8 Practical BIML Tips

You can leverage Business Intelligence Markup Language – or BIML – to automate the creation of Microsoft SQL Server Integration Services (SSIS) Packages. The popular open source BIDSHelper project includes Biml functionality, enabling anyone to write and execute BIML...