In this post I want to show a couple of ways to order the data that comes into the pipeline. a number of people have asked me about this primarily because there are a number of ways to do it but also because some components in the pipeline take sorted inputs. One of the methods I show is visually easy to understand and the other is less visual but potentially more performant.  Read more...

It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.  Read more...

MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.  Read more...

MVP Brian Knight shows how you can use precedence constraints to control the flow of your SSIS packages.  Read more...

This SQL School video shows just how you can sort the data in your SSIS packages.  Read more...

Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.  Read more...

In this video, MVP Brian Knight shows how you can use SSIS to work with files on your drive: renaming them, moving them, and more.  Read more...

MVP Brian Knight brings us a look at how you can easily debug your Integration Services packages.  Read more...

This edition of SQL Server examines the various options available in Integration Services configuration files.  Read more...

In this SQL School video, MVP Brian Knight dives into the Execute SQL task in Integration Services. You will learn how to add parameters to this task to customize its behavior.  Read more...

Integration Services contains a tremendous number of ways to transform and work with data. MVP Brian Knight dives into the Row Count transform in this edition of SQL School. This shows how you can monitor the number of rows in a transform.  Read more...

In this new SQL School video, MVP Brian Knight shows how you can schedule your SSIS packages to execute at a specific time or on a recurring schedule.  Read more...

Integration Services is an ETL programming environment that gives you a tremendous number of options. In this video, MVP Brian Knight shows how you can change your connections dynamically.  Read more...

This video shows how you can use Management Studio to execute your Integration Services packages.  Read more...

Integration Services is the ETL platform for SQL Server. In this installment of SQL School, Brian Knight shows how to add a timestamp (current date) to the name of a file.  Read more...