SSIS Snack: The Sort Transformation

Posted on March 22, 2010Updated on October 21, 2017by Andy LeonardCategories:Uncategorized

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 Cancel reply

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

Next Live Training:

	A Day of Azure Data Factory live and online 9:00 AM-4:30 PM (ET) 17 Sep 2025. Register today!
	A Day of Fabric Data Factory live and online 9:00 AM-4:30 PM (ET) 24 Sep 2025. Register today!

Subscribe to my Newsletter

Need Help?

I still deliver consulting! I help enterprises implement Fabric Data Factory and Azure Data Factory solutions, help data teams rescue data warehouse projects, and support businesses by validating data architecture. Contact me. I can help.

Training

Azure QuickStart Premium includes access to all Enterprise Data & Analytics' Fabric, Azure, and Azure Data Factory training for 1 Year! Register today!

Do you need to level-up your Data Engineering skills in a hurry? Premium Level includes all Azure QuickStart Premium content plus SSIS and SSIS Catalog content. Register today!