Hi All, Can I generate Row_Number In SSIS Pakcage using any transformation.I can Go for script Task likePublic 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..

Check out this solution, should be about righthttps://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3741062&SiteID=17

Thank You Charles... It really helped me a lot...Thank You Very Much..

Charles, One More thingCan I get LikeRow_Number(partition by column0,column1, order by column2)..? Do U have any script for this..please...I also need 'order by' clause...The Previous code is working fine but..I need to group by 2 columns...and order by 1 more column Help Me out Plz..

You'll have to drop a Sort operation before the Script task and sort on Column2. Wouldn't the logic for partitioning by 2 columns will look like the existing code, just check for the other value?

Thank YOu Very Much Charles..

The link mentioned above is not working..........can i have the code please , how to use row number in script task..

hi binny, I am thiru..i have same proble row number partition use ssis .But i don't get idea how to partition in ssis. i did it checked ur form in https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3741062&SiteID=17.It could not be open it.so pls send me details about partition in ssis in my mail id. thanks, thiru mail:thirumurugan_888@hotmail.com