I have the following recordset in the data flow.
View Complete Post
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
Can anybody show me an example how to create new Derived Column ( e.g. ABC-Column-Name = "M" - its value ) using Script Component "transformation" the same as create a using Derived column Task?
I have these codes that gives my the desire output before. These codes scanned the records and if the current RowType <> "TENDER" and previousC1 = "TENDER", assign the value of RowType = "TOTAL" to a variable ouput.
Before, if the RowType is "TENDER", it means that its the end of a transaction group.
Public Class ScriptMain
Private dt As DataTable
Private previousC1 As String = String.Empty
Public Overrides Sub PreExecute()
dt = New DataTable()
Can any body send code for how to execute a parameterized stored procedure using ssis dataflow script component transformation using .net
I know how to execute storedproc using control flow script task, but I need using ssis dataflow script component transformation.