T Childers (12/7/2012)

---

Just in case anyone else has gotten here for the same reason I did which was you're trying to build an SSIS package based on a stored procedure that is selecting the data from a temporary table (Select column1, column2, column3 from #tablename).

If you can, it worked better if we used a table variable instead:
DECLARE @tablename
(Column1 varchar(10),
column2 varchar(10),
column3 varchar(10)
)

Of course, the problem with that is that the data is put all in memory instead of TempDB, but it did resolve our issue.

   
-- Publish metadata for SSIS
   if 1 = 0
   begin
     select 
       cast(null as bit) [Col1],
       cast(null as int) [Col2],
etc etc
   end

exec usp_proc1 with result sets 
( 
   ([Col1] bit,
    [Col2] int
);