Tim Van Wassenhove
Passionate geek, interested in Technology. Proud father of two
Home
All posts
Tags
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...
← Prev page
Next page →