Opinion: Do your bulk data manipulation in T-SQL, not in row operations in SSIS

added by DotNetKicks
8/19/2019 3:43:57 PM

1 Kicks, 155 Views

I really love SQL Server Integration Services (SSIS). In fact, I wish Microsoft was giving it far more love than it is. So many of my clients use it, but unfortunately, not everyone uses it well, or for the right things. One really common mistake is to perform lots of row-by-row logic within the SSIS ...