Hans Michiels, Author at SQL Shack - articles about database auditing, server performance, data recovery, and more

Introduction

The SSIS Script Task is a very powerful component to use in a SSIS package, and most of the time you can achieve with it what you want. Still, I have faced a few situations where a Script Task was not the best solution. In those cases I made a .NET Console application and executed it from within a SSIS package.

SQLShack

Hans Michiels

Executing your own .NET console application from SSIS

Introduction

How to mimic a wildcard search on Always Encrypted columns with Entity Framework

Introduction

Temporal Table applications in SQL Data Warehouse environments