SSIS – Unpack a ZIP file with the Script Task
A while ago I needed to unpack a couple of zip files from SSIS. There is no Microsoft SSIS task
Tag: SSIS
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
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
Start / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch file
A lot of developers have SQL Server and its different services running on their PC or notebook to develop or
SSIS – Decrease your fact table loading time up to 40%
Replace the multiple “Lookup Error Output” Derived Columns and Union All’s with a single Derived Column and get a performance
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 