SSIS Blob Encoding error ??

• isuckatsql

  SSChampion

  Points: 10381

  More actions

  November 23, 2011 at 11:05 am

  #252341

  Cannot implicitly convert type 'string' to Microsoft.sqlserver.dts.pipeline.blobcolumn - error

  Input and output fields are the same text formats.

  public override void Input0_ProcessInputRow(Input0Buffer Row)

  {

  // Parse Company Name //

  ArrayList mailList = ValidateEmailRow(System.Text.Encoding.Default.GetString(Row.EmailAddressText.GetBlobData(0,(int)(Row.EmailAddressText.Length-1))));

  DateTime dt;

  dt=DateTime.Now;

  Row.currentdate = dt;

  Guid g;

  g = Guid.NewGuid();

  Row.profileid = g;

  int i = mailList.Count;

  if(i>0)

  {

  Row.email1 = (i>0)?mailList[0].ToString():""; - error lines are next 5 lines

  Row.email2 = (i>1)?mailList[1].ToString():"";

  Row.email3 = (i>2)?mailList[2].ToString():"";

  Row.email4 = (i>3)?mailList[3].ToString():"";

  Row.email5 = (i>4)?mailList[4].ToString():"";

  }

  mailList = null;

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 23, 2011 at 1:22 pm

  #1412453

  Have you tried it without the conditional for just the first column so see if the conditional is causing the problem?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• isuckatsql

  SSChampion

  Points: 10381

  More actions

  November 23, 2011 at 1:43 pm

  #1412469

  Let me give that a shot.

  Thanks

• isuckatsql

  SSChampion

  Points: 10381

  More actions

  November 23, 2011 at 1:47 pm

  #1412472

  Row.email10 = mailList10[0].ToString():"";

  If this is what you meant, i still get the same error 🙁