title: SSIS Script Component
body: <p>I found this piece of code which works fine for my input (a string of CSV). The package runs fine, but instead of getting 5 columns of output, I only get 2 columns. I added additional columns in the Script Component and also changed their data types to the suitable ones. The input is 643492,PV STRIP 1X1 UTILITY UP,,67.5,393446. Out of this entire string, I only get 643492 in one column and PV STRIP 1X1 UTILITY UP in another. Rest of the string comes out blank no idea why. Experts kindly help. I dont know anything about .net and I am new to SQL Server as well. </p>
  
  <pre><code>Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
      Dim strRow As String
      Dim strColSeperator As String
      Dim rowValues As String()
      strRow = Row.Line.ToString()
      If strRow.Contains(",") Then
          strColSeperator = (",")
      ElseIf strRow.Contains(";") Then
          strColSeperator = ";"
      End If
  
      rowValues = Row.Line.Split(CChar(strColSeperator))
      Row.Code = rowValues.GetValue(0).ToString()
      Row.Description = rowValues.GetValue(1).ToString()
  
  End Sub
  </code></pre>