use something like this

function main()
dim gv as dts.globalvariable
dim count as integer
count=1
if count=1 then
'get data from first record
set gv=dtssource("col1")+dtssource("col2") or whatever you want to do
with the two columns
end if
count=count+1
Main = DTSTransformStat_OK
end function




Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!