Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

HELP WITH SCRIPT COMPONENET, SSIS

Go down

HELP WITH SCRIPT COMPONENET, SSIS Empty HELP WITH SCRIPT COMPONENET, SSIS

Post  sssqllearner on Wed Feb 25, 2015 12:46 pm

HI,

I HAVE SCRIPT WHICH GIVES ME "AREA 3" INFO IN MY STAGING TABLE. HOWEVER I HAVE REQUIREMENT NOW WHERE I NEED TO INSERT AREA 1 AND AREA 2 FROM BELOW TABLE AS WELL IN THE STAGING TABLE, CAN ANY ONE PLEASE HELP me TO UPDATE THE SCRIPT SO THAT I CAN INSERT AREA 1 AND AREA 2...... I am not sure how to use script component yet and hence i would really appreciate if someone can guide me.

HELP WITH SCRIPT COMPONENET, SSIS 112

CURRENT SCRIPT IS:
 ' Process Row 3 - Skip row that has first column with a single space
                    If currentField.Length = 0 And ColumnNo = 1 Then
                        Continue While
                    End If

                   

                    ' Process area3 of regular row if it starts with 2 digits and a space
                    If currentField.Length > 2 And ColumnNo = 1 Then
                        If IsNumeric(currentField.Substring(0, 1)) _
                            And IsNumeric(currentField.Substring(1, 1)) _
                            And currentField.Substring(2, 1) = " " Then
                            area3= currentField.Substring(0, 2)
                            'skip to next column
                            Continue For
                        Else
                            'skip row as not at area 3
                            RowsSkipped = RowsSkipped + 1
                            Continue While
                        End If
                    End If

Thanks,
Regads

sssqllearner

Posts : 8
Join date : 2014-09-16

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum