Hi Vipin,

you have to use the Object variable type and pass that variable to script task.

please see the following article for your reference:

http://sqlage.blogspot.com.au/2013/07/ssis-how-to-read-object-type-variable.html

http://beyondrelational.com/modules/2/blogs/106/posts/11133/ssis-reading-object-variable-in-script-task.aspx

Thanks,

Zaim Raza

See if this helps

http://www.selectsifiso.net/?p=288

Hi,

If you want to chose all columns in your data, you shouldn't use dataflow task.

Step1: use SQL task to chose your data into variable:

In that task you should set "Result set" as "Full result set" and make a variable. In my case it call Params ("User::Params")

Step2: in script task you can use this variable:

System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();
DataTable tmp = new DataTable();
adapter.Fill(tmp, Dts.Variables["User::Params"].Value);
if (tmp.Rows.Count == 1)
{
    foreach (DataRow row in tmp.Rows)
    {
        //put a row into string using \t delimiter
        tmpStr = string.Join("\t", row.ItemArray)+"\n";
    }
}

• Edited by xjomanx 4 hours 21 minutes ago

Thanks for you update sir ,

I want hash value of my all column

below is my original code which is static

************

Public Class ScriptMain
Inherits UserComponent

Dim md5 As MD5CryptoServiceProvider = New MD5CryptoServiceProvider()

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim columnContents As Byte() = UnicodeEncoding.Unicode.GetBytes(Row.Col001 + Row.Col002 + Row.Col003 + Row.Col004 + Row.Col005 + Row.Col006 + Row.Col007 + Row.Col008)
System.Windows.Forms.MessageBox.Show(columnContents.ToString())

Dim hash As Byte() = md5.ComputeHash(columnContents)
Dim hashString As String = Convert.ToBase64String(hash, Base64FormattingOptions.None)

Row.RowChecksum = hashString
End Sub
End Class

********

I have to use script component instead of script task

how can I incopropare my code with your code ?

regards,

Vipin jha

You can use reflection to loop through all input columns in a Script

You can use reflection to loop through all input columns in a Script Compo

Why do you need to use script component instead of script task?

What the purpose?

In script component you cannot change columns on fly, because row class is generating, when you choosing input columns:

You can try to change input row class, but i think that it will be error in script.

Class can change here: