A weird question, but i need to do a sorting inside of the Script Component. I have a RowNumber Column, that i need to sort by ascending.
Is their away to do this?
View Complete Post
how to access the package level variables within a script component in SSIS 2008
#) I have a Script Task which is of Transform Type and Takes Input from OLEDB Source
#) Now I can easily parse through all records and successful push them in OLEDB destination.
#) Now I need to add an extra row in Script Task, which calculates the totals of the amount across Rows. This Row should be added at end.
Can anybody help me on this.
Thanks in advance.
I have this recordset in my data flow.