Unwichtiges nach Relevanz sortieren...

Correct settings for importing Unicode files with SSIS

Just a reminder post for the correct settings to import Unicode files with SSIS:

In the general settings of the “Flat File Connection Manager Editor” select the code page “65001 (UTF-8)” and the Locale “Germany” (or whatever applies to you).


In the advanced settings choose the columns, that contain Unicode characters. In my case I have only some columns containing Unicode data. The standard string DataType is “string [DT_STR]. For Unicode choose “Unicode string [DT_WSTR]”


Convert TS Files to MPEG-4 with Avidemux

I bought the Odsys Twin Video Player for my kids and struggled a little bit on how to get TS files from my Technisat Digit HD8-C Recorder. I use Avidemux for this job and here are my settings:

First open the TS File in Avidemux:

For Video choose MPEG-4 ASP(Xvid). Configure it to use “Video Size (Two Pass)”. In Filters select Resize and set it to 480x274.

For Audio choose MP3 (lame) and finally set the format to AVI. That’s it.

CoRD–RDP Remote Desktop for Mac

I had the very strange problem, that the RDP Client for Mac from Microsoft did not work with nested RDP sessions. That means when I connect from my Mac to my Windows 7 Desktop and from that to a remote Windows Server, the shift key was only working occasionally. Argh!

The solution is CoRD! A fancy RDP Client for Mac ( Works like a charm!

Kerberos Troubleshooting

Hin und wieder darf ich mich mit Kerberos Authentifizierung rumärgern. Vor allem beim Setup von neuen Systemen bringt mich das meist an den Rand der Verzweiflung. Retter in der Not ist da DelegConfig ( Quasi das Schweizer Taschenmesser für die Kerberos Delegierung mit mehreren Servern. Erwähnenswert sei noch folgender Artikel zur Einrichtung von DelegConfig unter IIS 7: