Phil Parkin (10/15/2013)
Nevyn (10/15/2013)
Phil Parkin (10/13/2013)
...it's still not actually being done by SSIS... it's being done by a script.
Well, I think we are drifting into a grey semantic area here.
SSIS natively provides the flexibility to use scripts as part of packages - they are fully integrated and not some sort of add-on or hack. In this case, the data pipeline runs through a script which processes each row in (a pre-sorted) order and uses variables to track row numbers. It's the pre-sort and row-by-row processing that slow things down, of course.
SSIS also natively provides the flexibility to use a T-SQL query in the data source that generates the same numbers (or from a staging table if the original data source can't be queried via T-sql). Same semantic grey area, no?
I'd say that that was an even greyer shade than the original 🙂 I wonder whether Jeff would consider the use of T-SQL within SSIS to be ' done by a script' ...
BWAAA-HAAA!!!! It certainly would NOT be an "SSIS Only" solution. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.