Taking A Filename Into Substrings

I have filename with the following format

461#Pipeline#0978541235#1.pdf

where # is the seperator between different data in the filename, in .NET i achieved to save the different data in the filename to seperate variables like this


Dim siebelId, accountNumber, docType As String

Dim counter As Integer = 0

Dim sites As String() = Nothing

sites = extension2.Split("#")

Dim s As String

For Each s In sites

If counter = 0 Then

siebelId = s

End If

If counter = 1 Then

accountNumber = s

End If

If counter = 2 Then

docType = s

End If

counter = counter + 1

Next s


How can i achieve this in SSIS where i can save these to variables for later use in an Execute SQL Task ?