SSIS : loading data from recordSet (variable :object) by Script task

• Yassine LD

  SSC Veteran

  Points: 249

  More actions

  March 13, 2014 at 8:30 am

  #289412

  Hi,

  i was trying to get data from a recordSet variable. but it's not working :ermm:

  Code :

  public void Main()

  {

  OleDbDataAdapter A = new OleDbDataAdapter();

  System.Data.DataTable dt = new System.Data.DataTable();

  A.Fill(dt, Dts.Variables["User::Var1"].Value);

  // TODO: Add your code here

  foreach (DataRow row in dt.Rows)

  {

  string DeviceID;

  object[] array = row.ItemArray;

  DeviceID = array[0].ToString();

  // I Declare both variables ID And Name as String, So I can show in Messagebox. You can Declare ID as INT and set the value and use

  //However you want to use.

  MessageBox.Show("ID Value=" + DeviceID);

  }

  Dts.TaskResult = (int)ScriptResults.Success;

  }

• kl25

  Hall of Fame

  Points: 3752

  More actions

  March 14, 2014 at 9:33 am

  #1697185

  Two different approaches presented in these articles:

  SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers[/url]

  SSIS Design Pattern - Read a DataSet From Variable In a Script Task

  If these approaches don't meet your need, try searching for 'SSIS shredding a recordset' or 'SSIS shredding an object'.