DataBaser.Net: SSIS-컬럼정렬

'a,c,b,z,f' 와 같이 컬럼을 합치고...
split해서 문자열 배열에 넣고
array.sort(str)를 이용해서 정렬한후..
다시 split해서 새로운 컬럼에 넣던지.. 옛날 컬럼에 넣던지.. 알아서 하슈..

' Microsoft SQL Server Integration Services user script component
' This is your new script component in Microsoft Visual Basic .NET
' ScriptMain is the entrypoint class for script components

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain
    Inherits UserComponent

    Public Overrides Sub 입력0_ProcessInputRow(ByVal Row As 입력0Buffer)
        '
        ' Add your code here
        '
        Dim str(5) As String
        str = Row.col.Split(CChar(","))
        Array.Sort(str)
        Row.sort = str(0) & "," & str(1) & "," & str(2) & "," & str(3) & "," & str(4)
    End Sub



End Class