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.