I had considered a table variable but...
"Tables variables cannot be used in a INSERT EXEC or SELECT INTO statement."
http://support.microsoft.com/kb/305977/en-us
Thank goodness for old style temp tables!
The SSIS package generates a couple of excel spreadsheets, and emails them.
With reporting set to OFF, the following sort of text is returned systematically by the dtexec program.
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 15:55:55
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 15:55:55
Finished: 15:56:02
Elapsed: 6.719 seconds