Home Dashboard Directory Help
Search

SSIS - Add "Add Row Number" Option to OLE DB Source by Todd McDermid


Status: 

Closed
 as Won't Fix Help for as Won't Fix


7
0
Sign in
to vote
Type: Suggestion
ID: 668245
Opened: 5/12/2011 1:06:59 PM
Access Restriction: Public
0
Workaround(s)
view

Description

Add a new option to "add row number" to the OLE DB Source component.
Using row numbers within a Data Flow is a very common requirement when doing inter-row comparisons or rankings. Currently, this requirement can be filled by using a synchronous Script component. However, it would be much easier and reliable to add this simple capability to the OLE DB Source.
Details
Sign in to post a comment.
Posted by Microsoft on 6/29/2011 at 4:35 PM
Another good suggestion, but unfortunately unlikely to make it into "Denali." If you have any more information that might cause us to re-evaluate the priority of this request, please let us know.

-- The SSIS Team
Posted by Koen Verbeeck on 5/12/2011 at 11:02 PM
Such an add-on would be fantastic! No more fuddling with 3rd party components or writing a script component!
Posted by AlvinRamard on 5/12/2011 at 6:34 PM
I agree with Sudeep Raj. If the feature ia added, why not add it for all Sources?
Posted by Sudeep Raj on 5/12/2011 at 2:00 PM
To take this a step forward, it would be really nice to have similar feature in all the Sources available in the Data Flow Task and the user should have the option of setting it ON or OFF.
Sign in to post a workaround.