One other thing, i've just be doing some trial and error work, the very first step of the dts is a series of 10 truncate table commands, with the log...

Hi there,

it looks like the data may not be coming back because you are using a date in your join

left outer join ClaimAmount b ON (a.CustomerID = b.CustomerID and a.PlanID...

That works a treat. I was pulling my hair out with that one.

Many thanks,