Row number in SSIS
Public Class ScriptMain : Inherits UserComponent Private _RowNumber As Integer = 1 Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) Row.RowNumber = _RowNumber _RowNumber += 1 End SubEnd ClassBut It generates the sequence of RowNumber...I want this sequence should be partitioned by some columnand order by some other column... How Can I Get That in SSIS..?Is there any script for that.. I dont want to write t-sql in my Package, Thats My boss Order..Thanks.. Reply Quote
December 17th, 2010 4:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics