A lot of time people ask me if there is a way to read object variable in Script task. It comes in handy when you wish to work on the results of an Execute SQL query. Generally object variables are used along with Foreach Loop. However cases arise where you would like to read them separately. So how do you do it?

Here is a sample to raed an object variable "objTest":

using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using Microsoft.SqlServer.Dts.Runtime;
using System.Xml;
using System.Data.OleDb;

namespace ST_5aea2611332745a298a74702e4129af8.csproj
    {
        [System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
        public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
        {

            #region VSTA generated code
            enum ScriptResults
            {
                Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
                Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
            };
            #endregion


            public void Main()
            {
                // TODO: Add your code here
                Dts.TaskResult = (int)ScriptResults.Success;
                OleDbDataAdapter oleDA = new OleDbDataAdapter();
                DataTable dt = new DataTable();
                DataColumn col = null;
                DataRow row = null;
                string strMsg = null;

                oleDA.Fill(dt, Dts.Variables["objTest"].Value);

                foreach (DataRow row_ in dt.Rows)
                {
                    row = row_;
                    foreach (DataColumn col_ in dt.Columns)
                    {
                        col = col_;
                        strMsg = strMsg + col.ColumnName + ": " + row[col.Ordinal].ToString() + Environment.NewLine;
                    }
                    MessageBox.Show(strMsg);
                    strMsg = "";
                }

                Dts.TaskResult = (int)ScriptResults.Success;
            }

        }
    } 

Imports System.Data
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Windows.Forms
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Xml
Imports System.Data.OleDb

Namespace ST_5aea2611332745a298a74702e4129af8.csproj
	 _
	Public Partial Class ScriptMain
		Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

		#Region "VSTA generated code"
		Private Enum ScriptResults
			Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success
			Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
		End Enum
		#End Region


		Public Sub Main()
			' TODO: Add your code here
			Dts.TaskResult = CInt(ScriptResults.Success)
			Dim oleDA As New OleDbDataAdapter()
			Dim dt As New DataTable()
			Dim col As DataColumn = Nothing
			Dim row As DataRow = Nothing
			Dim strMsg As String = Nothing

			oleDA.Fill(dt, Dts.Variables("objTest").Value)

			For Each row_ As DataRow In dt.Rows
				row = row_
				For Each col_ As DataColumn In dt.Columns
					col = col_
					strMsg = strMsg & col.ColumnName & ": " & row(col.Ordinal).ToString() & Environment.NewLine
				Next
				MessageBox.Show(strMsg)
				strMsg = ""
			Next

			Dts.TaskResult = CInt(ScriptResults.Success)
		End Sub

	End Class
End Namespace