by Marco Schreuder | Dec 18, 2013 | In2BI
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...
by Marco Schreuder | Dec 8, 2013 | In2BI
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...
by admin | Sep 17, 2013 | In2BI
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...
by Marco Schreuder | Sep 17, 2013 | In2BI
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...
by admin | Aug 31, 2013 | In2BI
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...