Accessing rows of a table using script task

Hi all,

Can anyone tell me how to access all the rows in a table using script task?

I want to access each row in a table get their values and put it in a global variable. Can anyone hwlp mw with this please.

Thanks in advance,

Why do you want to use the Script Task for this? You could just use an OleDBSource and push it to a DataReaderDestination (DataSet)

What datatype will you be using for your global variable? Will it be a single variable, or multiple variables?

|||

Hi,

Thank you Sean

I am actually logging all the status information of my package at each stage into the table which has about 20 columns and on the completion of the package i wanted send an email which gets its information from the columns values of the table.

Thanks,

|||

if you want to send 1 email for each row of the table, then you could make a dataflow that uses your logging table as a source and uses a recordset destination. then use a foreach loop (containing the sendmail task) over the recordset to send 1 mail per row. this is if you want to send the emails at the end of all other processing, when the status table is filled up.