The SSIS temp table 'hack' is described here[/url]. A relatively straightforward publication of meta data does the job.

In 2012, the hack changes, but given the forum, I'm assuming that you are running 2005.