SSIS – Lookup is case sensitive
A while ago I figured out that the lookup transformation is case sensitive. I used a lookup to find dimension
Tag: Integration Services
SSAS – Clear SSAS cache with an SSIS package
Often I see developers on different forums asking how they can clear the SSAS cache. You can achieve this by
SSIS – Convert various String date formats to DateTime with the Script Task
The script below is really nice if you need to convert String dates that come in different (unexpected) formats. Just
SSIS – Non-blocking, Semi-blocking and Fully-blocking components
How can you recognize these three component types, what is their inner working and do they acquire new buffers and/or
Jorg Klein's Blog 