Thanks - that'll save us plenty of work.
The original sp was of the form:
select * into #temp from contacts.dbo.tblindustry
select * from #temp
and I've replaced it with:
select * into ##temp from contacts.dbo.tblindustry
select * from ##temp
This works, and is now editable in the DTS package. Actually, the original worked but was not editable in DTS when going from the source to destination tabs. This is still a little hazy to me, because presumably the resulting source recordset (from the select * from #temp) is cached in tempdb and should not still have a reference to the temp table. Anyway, you've solved the problem in the DTS designer, and I'll additionally modify the packages to remove the global temp table in a separate dynamic sql task.