Sorting data in the SSIS Pipeline (Video)

Posted on SQLIS See other posts from SQLIS
Published on Sat, 29 May 2010 20:27:00 +0100 Indexed on 2010/05/29 19:35 UTC
Read the original article Hit count: 310

Filed under:

Data Flow

|

Transformations

|

Sources

|

videos

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.

© SQLIS or respective owner

Related posts about Data Flow

Introduction to Control Flow and Data Flow of SSIS 2008

as seen on Internet.com - Search for 'Internet.com'
Learn about two primary components of SQL Server 2008 Integration Services packages and their graphical representation in the Business Intelligence Development Studio. >>> More
timetable in a jTable

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to create a timetable in a jTable. For the top row it will display from monday to sunday and the left colume will display the time of the day with 2h interval e.g 1st colume (0000 - 0200), 2nd colume (0200 - 0400) .... And if i click a button the timing will change from 2h interval to 1h interval… >>> More
Reading data from an Entity Framework data model through a WCF Data Service

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This is going to be the fourth post of a series of posts regarding ASP.Net and the Entity Framework and how we can use Entity Framework to access our datastore. You can find the first one here , the second one here and the third one here . I have a post regarding ASP.Net and EntityDataSource. You… >>> More
SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

as seen on SQL Authority - Search for 'SQL Authority'
There has been much fanfare over the new SQL Server 2012, and especially around its new companion product Data Quality Services (DQS). Among the many new features is the addition of this integrated knowledge-driven product that enables data stewards everywhere to profile, match, and cleanse data.… >>> More
Modifying a HTML page to fix several "bugs" add a function to next/previous on a option dropdown

as seen on Stack Overflow - Search for 'Stack Overflow'
SOF, I've got a few problems plaguing me at the moment and am wondering if anyone could assist me with them. I'm trying to get Next Class | Previous Class to act as buttons so that when Next Class is clicked it will go to the next item in the dropdown list and for previous it would go to back one… >>> More

Related posts about Transformations

Dealing with transformations in WPF: PartII-Custom and advanced 2D transformations

as seen on C# Corner - Search for 'C# Corner'
In a previous article we've discovered the different transformation modes. In this article, we continue discovering the transformations. >>> More
Dealing with transformations in WPF: Part I - Standard 2D Transformations

as seen on C# Corner - Search for 'C# Corner'
In WPF there are more than one transformation, I will try to present them the 2D ones one by one including some useful related techniques. >>> More
VS 2010 SP1 BETA – App.config XML Transformation Fix

as seen on Exceptional Code - Search for 'Exceptional Code'
The current version for App.config XML tranformations as described in a previous post does not support the SP1 BETA version of Visual Studio. I did some quick tests and decided to provide a different version with a compatibility fix for those already experimenting with the beta release of the service… >>> More
WPF Wonders: 3D Drawing with Textures, Transformations, and Realism

as seen on Internet.com - Search for 'Internet.com'
To build realism into 3D scenes, you need to draw with the appropriate materials—and transformations help make the drawing process much simpler. >>> More
WPF Wonders: Transformations (and Robots!)

as seen on Internet.com - Search for 'Internet.com'
WPF's transformations make it easy to move, scale, or rotate objects, and simplify building complex moveable 3D shapes. >>> More