SSIS Snack: The Sort Transformation

Introduction

The Sort Transformation provides SSIS developers a mechanism for sorting a data stream in the Data Flow Task pipeline.

A Use Case

I have a text file as a source that contains four generic columns: Column 0, Column 1, Column 2, and Column 3. I’ve added a Sort Transformation

 

 

 

 

 

 

 

 

 

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.