Attention: open in a new window. PDFPrint

String to DateTime on SSIS

Last Updated on Thursday, 27 August 2009 13:09 Thursday, 27 August 2009 12:50

The Microsoft SQL Server Integration Services provide an easy way and mostly straightforward way to perform ETL (Extract Transform Load) operations on an SQL Server 2005 or 2008. It provides a number of tasks to do transformations, conversions and other stuff you might perform around the data you like to load into or extract from your database.

Nevertheless, there are some stumbling blocks you might find. Today, I found one of them: String to Date conversion!

If you are using flatfiles as a data source or perform some pivot-transformation, you might want to convert a string representation into a datetime value. This might be done by the datatype conversion task, but if your date has some "non standard" format, this will fail. So I created a transformation script as little workaround and. A date in my desired format looks like this:

28.11.2008 18:20

The script uses the DateTime.ParseExact-Method provided by the .NET framwork. The VB script looks like this:

Read more: String to DateTime on SSIS

Attention: open in a new window. PDFPrint

VMWare Server 2 on Gentoo (amd64)

Last Updated on Tuesday, 01 December 2009 22:10 Tuesday, 25 August 2009 08:19

I recently decided to switch from vmware server 1 to vmware server 2 as I had some trouble to get the vmware modules running with my 2.6.29 gentoo kernel. It was not a big deal to get it emerged on my machine, but it I had to do some fixes to get it running on my amd64-system as it was not possible to log into the web interface with the "out-of-the-box" configuration. Theese are the steps I had to do to get it running:

1. Emerge VMWare Server

First, make sure you have unmasked the desired version of the server. I added the following lines to my /etc/portage/package.keywords:

=app-emulation/vmware-modules-  ~amd64
=app-emulation/vmware-vix-*  ~amd64
=app-emulation/vmware-server-*  ~amd64


Read more: VMWare Server 2 on Gentoo (amd64)

Attention: open in a new window. PDFPrint

Yet another mail filtering article

Last Updated on Saturday, 23 January 2010 21:42 Thursday, 20 August 2009 10:48

Why such a tutorial again?

Well… I know that there are tons of tutorials out there, how you get mail filtering running on your mailserver using courier imap, maildrop, spamassassin and clamav. So this might look like an other: "Hey, look, I've got it running post...".

I do not want to reeplain, how to configure spamassassin or clamav or something like this. I just want to show you in a brief article, how you can call spamassassin and clamav directly from a maildrop script. My problem with most of the solutions out there has been, that I use a mysql database for account management and vmail on my server which allows transport daemon selection per domain or account. So it is no option for me to use spamassassin before maildrop in the mail handling queue. An other reason most descriptions did not fit is, that I did not want to change my mailservers configuration ("never touch a running system"). So just updating the filter script was the easiest option for me.

Read more: Yet another mail filtering article

Attention: open in a new window. PDFPrint


Last Updated on Friday, 04 September 2009 12:40 Tuesday, 18 August 2009 14:10

Using the COLLADA DOM libraries is straight forward, if you know, where to start. So I will give a little example, how to load a .dae-file and how to locate some information inside the dom tree. First of all, we have to include COLLADA into our C/C++ file using the following includes:

#include <dae.h>
#include <dom/domCOLLADA.h>

We extend our application by a little main method that loads a .dae-File. If you need a .dae-file

Read more: Using COLLADA DOM

Attention: open in a new window. PDFPrint Layman Overlay

Last Updated on Tuesday, 18 August 2009 14:44 Tuesday, 18 August 2009 11:51

What is a portage overlay?

The official gentoo portage contains all official ebuild for your gentoo system. Ebuild are the definition for packages you can install using emerge. Of course, the overlay does not contain all applications available out there. There is a great number of applications not officially supported by the gentoo portage, as it is not possible to manage and add all applications out there. So there might come the time where you want to install an application that is not in the portage.

Read more: Layman Overlay

Attention: open in a new window. PDFPrint


Last Updated on Tuesday, 18 August 2009 14:44 Tuesday, 18 August 2009 10:36

What is COLLADA?

Collada (COLLAborative Design Activity) claimes to be an open interchange format between different 3D applications. The COLLADA development is managed by the Khronos Group, a non-profit consortium consisting of companies like Apple, Sun Microsystems, Sony Computer Entertainment, Intel Corporation, AMD, NVIDIA and id Software. COLLADA is developed under the MIT License and for this it is free to use for you.

Read more: COLLADA DOM on Gentoo


Page 4 of 4