Create an array of strings in SSIS

By Allen Stoner

If you need to use an array of strings in SSIS it is a little difficult to create it as a variable in the package. It takes defining the package variable as a system.object and calling a script task, either VB or C# (example is VB.NET). In my example I set System:Package name as a ReadOnly variable and User:Categories as ReadWrite, this is also the one defined as the system.object. The sample Main procedure sets the first element of the string array to the package name.

Public Sub Main()
        Dim arr As String()
        ReDim arr(0)

        arr(0) = Dts.Variables("System::PackageName").Value
        Dts.Variables("User::Categories").Value = arr
        Dts.TaskResult = ScriptResults.Success
End Sub

Create an array of strings in SSIS  (4901 Views)