One Way to Create a Parquet File from SQL Server Data

Yesterday I was coding away, deep into using C# to decompress and parse Excel XML so I could read data from a specific worksheet in a workbook on a server without Excel objects installed, when I saw the following on Twitter: For those of you who do not already know… I Don’t Switch Contexts Well I …
Continue reading One Way to Create a Parquet File from SQL Server Data

Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9

Things change. Things change in software. Things change regularly in software. If you take nothing else away from this post, please take those nuggets of wisdom. Last week, my latest book – titled Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond, (Second Edition) was …
Continue reading Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9

Building Custom Tasks for SQL Server Integration Services, 2nd Edition is Available

Update: Please be sure to read Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9 for important updates to the demo code. I am honored, humbled, and excited to announce the release of Building Custom Tasks for SQL Server Integration Services, 2nd Edition! In the first edition of this book, the demo task is …
Continue reading Building Custom Tasks for SQL Server Integration Services, 2nd Edition is Available

Foreword – Building Custom Tasks for SSIS 2nd Edition

I’m excited to announce Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond 2nd Edition is available for pre-order at Amazon! I spent more time on this book and the demo task – the Execute Catalog Package Task – than any other book I’ve authored or …
Continue reading Foreword – Building Custom Tasks for SSIS 2nd Edition

SSIS Design Pattern: Use Script Tasks for ETL Instrumentation

I consider scripting in SQL Server Integration Services (SSIS) my data integration “get out of jail free” card. Why? If I cannot find a way to accomplish some requirement using SSIS’s built-in objects – tasks, containers, Data Flow components, etc. – I can usually write .Net code to fulfill the requirement. As stated in the …
Continue reading SSIS Design Pattern: Use Script Tasks for ETL Instrumentation