Hi

Your table script doesnt match the data you're inserting, field lengths need to be extended for that data.

I think you're after the coalesce function, something like this

select

adr_club_name+', '+coalesce(adr_state+', ',adr_intl_provience+', ','')+adr_country

from...

Thanks guys your comments are very helpful

Apparently there is never any reason to use SQL Server Destination in the real world. And members of the SSIS product team have said...