Oh, forgot one last question on this. If I load the data right into datatable object in my first dataflow task, do I have to declare an instance of this since I have to save the datatable object to the SSIS object variable?

so for example if I have an SSIS object variable named dtPayeeSummary and in my script component destination I load this. When I use it in my other data flow tasks will it know that this is a datatable?

ie. to get row count dtPayeeSummary.rows.count

or would I have to declare an instance:

dim dt as datatable = dtPayeeSummary

dt.rows.count.

reason I ask is because if I do have to declare an instance thats like having two copies and wasting memory correct?