ETL 指令碼任務

標籤：

Public Sub Main()
        ‘
        ‘ Add your code here
        ‘
        Dim sbWA As New StringBuilder
        Dim i As Integer
        Dim arWA As New Collections.ArrayList
        Dim bEOF As Boolean
        For Each r As DataRow In CType(Dts.Variables("dsWOACNBR").Value, DataSet).Tables(0).Rows
            i = i + 1
            bEOF = True
            sbWA.Append("‘,‘")
            sbWA.Append(r.Item(0).ToString + r.Item(1).ToString)

            If i Mod 100 = 0 Then
                bEOF = False
                Dim strWA As String = sbWA.ToString
                strWA = strWA.Substring(3) ‘...移除"‘,‘"字元，後面計算長度時需補上

                arWA.Add(strWA)

                sbWA.Remove(0, strWA.Length + 3) ‘...清空時需補上"‘,‘"已移除字元的計數

            End If
        Next

        If bEOF = True Then
            Dim strWA As String = sbWA.ToString
            strWA = strWA.Substring(3) ‘...移除"‘,‘"字元，後面計算長度時需補上

            arWA.Add(strWA)

        End If

        Dts.Variables("arWOACNBR").Value = arWA

        Dts.TaskResult = Dts.Results.Success
    End Sub

ETL 指令碼任務