Tim Van Wassenhove

Passionate geek, interested in Technology. Proud father of two

01 Aug 2011

TryGetResult

I think this entry has been in the pipeline for a couple of years now and today i have decided to finally post it 😉 I go...
15 Jul 2011

Launch DtExec from PowerShell

Running an SSIS package from PowerShell (using DTExec) can be as simple as: RunPackage -File 'C:\test.dtsx' -Dat...
13 Jul 2011

Building a Nums table (quickly)

A while ago i presented my approach to generate a nums table here. DECLARE @count INT = 1000; WITH [Nums1] AS ( SELECT 1...
13 Jul 2011

Using User-Defined Table Type with Identity column in ADO.NET

A while ago i wanted to use a User-Defined Table Type to pass in a set of records. Nothing special about this except tha...
19 May 2011

Set variables in SSIS package at runtime

The documentation on dtexec Utility (SSIS Tool) says the following: /Set propertyPath;value (Optional). Overrides the co...
09 May 2011

How to handle (short) bursts of work

Here is a summary of how businesses around me handle short bursts of work: When i go to the doctor: find an empty seat i...
21 Mar 2011

Invoke parameterized stored procedure with PowerShell

Here is a quick snippet that demonstrates how you can invoke a parametrized stored procedure with PowerShell: $CreateTra...
16 Mar 2011

Global hotkeys for iTunes on windows

These days i use iTunes as media player. Unlike winamp this program does not seem to support system-wide hotkeys to cont...
16 Mar 2011

Navigation to the webpage was canceled

Earlier today i ran into the ‘Navigation to the webpage was canceled’ when i tried to open a CHM file: Navig...
12 Mar 2011

Consume locally build software without overloading your $PATH

How do you consume locally build software? For a while now i have used the following approach: Create a ~/bin folder Add...