I have this recordset in my data flow.
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.
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?
Hey everyone. First let me say that I'm new to the forums and new to SSIS. I've been a .Net developer since the beginning but never used SSIS until now. With that said, here is my issue.
My Problem: I have a situation where I have data coming from a mainframe Db2 source and one of the fields is a state column. It can hold either the state code (NC) or the name of the state (North Carolina). Our target table
will only hold the 2-character state code. So I need to check the State column for each record and if the length is greater than 2 characters, I need to do a lookup and return the state code for the given state name.
I initially was going down the path of using a Conditinoal-Split task to split the records based on the state column being 2 characters or bigger, with a Fuzzy Lookup for the state name and then a Merge task to merge the two sets of records back together
before inserting into my target. However, I was in an SSIS training class this past week and ran this solution by my instructor and he thought that a Script Component would be better for this kind of transformation.
So I've been working on my second solution using a Script Component Transformation task and my input was the State column and my output was the transformed state code.&n