HOW TO CHECK IS OBJECT VARIABLE CONTAINS VALUE OR NOT

• squvi.87

  Default port

  Points: 1450

  More actions

  September 30, 2015 at 7:14 am

  #399116

  Hi There,

  Im giving an object variable as input for foreach loop.

  Value for the object variable was set by a sql task. if the obj variable is not contain any value it will through error.

  so I require to check whether an object variable contains data ?

  is there any possibility to check that in precedence constraint ?

• michal.lisinski

  SSCertifiable

  Points: 7201

  More actions

  October 13, 2015 at 5:52 am

  #1832965

  Hi

  Imho you can add a Script Task between and check your object variable,

  public void Main()

  {

  OleDbDataAdapter oda = new OleDbDataAdapter();

  DataTable dtb = new DataTable();

  // read object variable

  oda.Fill(dtb, Dts.Variables["YourObjVar"].Value);

  //count rows

  Dts.Variables["RowChk"].Value = (int)(dtb.Rows.Count);

  Dts.TaskResult = (int)ScriptResults.Success;

  }

  and set a Precedence Constraint where expression @[User::RowChk] > 0 ,

  of course, there are some other ways to do that.

  Best regards

  Mike