title: SSIS Script Component: Microsoft.SqlServer.Dts.Pipeline.BlobColumn
body: <p>Struggling with a C# Component. What I am trying to do is take a column that is ntext in my input source which is delimited with pipes, and then write the array to a text file. When I run my component my output looks like this:</p>
  
  <pre><code>DealerID,StockNumber,Option
  161552,P1427,Microsoft.SqlServer.Dts.Pipeline.BlobColumn
  </code></pre>
  
  <p>Ive been working with the GetBlobData method and im struggling with it. Any help with be greatly appreciated! Here is the full script:</p>
  
  <pre><code>public override void Input0_ProcessInputRow(Input0Buffer Row)
  {
      string vehicleoptionsdelimited = Row.Options.ToString();
      //string OptionBlob = Row.Options.GetBlobData(int ;
      //string vehicleoptionsdelimited = System.Text.Encoding.GetEncoding(Row.Options.ColumnInfo.CodePage).GetChars(OptionBlob);
      string[] option = vehicleoptionsdelimited.Split('|');
      string path = @"C:\Users\User\Desktop\Local_DS_CSVs\";
  
      string[] headerline =
      {
          "DealerID" + "," + "StockNumber" + "," + "Option"
      };
  
      System.IO.File.WriteAllLines(path + "OptionInput.txt", headerline);
  
      using (System.IO.StreamWriter file = new System.IO.StreamWriter(path + "OptionInput.txt", true))
      {
          foreach (string s in option)
          {
              file.WriteLine(Row.DealerID.ToString() + "," + Row.StockNumber.ToString() + "," + s);
          }
      }
  </code></pre>