Tim Van Wassenhove

Passionate geek, interested in Technology. Proud father of two

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...
12 Mar 2011

Dynamic scriptblock with PowerShell

Earlier this week i tried to run a command on a remote computer but it did not seem to work: $name = 'tim' $comp...