SQL SSIS 2012 - Metadata could not be determined

The metadata could not be determined because the statement 'SELECT   TOP 0 *

                           FROM   (SELECT 1,1,1,1,1,1,'none') as a (BatchID, LoadCount, FailedCount, SampleCo' in procedure 'ETL_DATLOAD_SAVEBatch_Bandwidth' is not compatible with the statement 'SELECT  a.*, b.FilePath as FilePath

                                  FROM   @OUT a

                                  LEFT

                                  JOIN   dbo.BULKLOAD_Basic b (no' in procedure 'ETL_DATLOAD_SAVEBatch_Bandwidth'.

Msg 11512, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1

The metadata could not be determined because the statement 'SELECT   TOP 0 *

                           FROM   (SELECT 1,1,1,1,1,1,'none') as a (BatchID, LoadCount, FailedCount, SampleCo' in procedure 'ETL_DATLOAD_SAVEBatch_Bandwidth' is not compatible with the statement 'SELECT a.BatchID, a.LoadCount, a.FailedCount, a.SampleCount, a.BadCustomerRows, a.BadMediaRows, b.Fi' in procedure 'ETL_DATLOAD_SAVEBatch_Bandwidth'.

declare @p1 int

set @p1=0

exec sp_prepare @p1 output,NULL,N'EXEC dbo.ETL_DATLOAD_SAVEBatch_Bandwidth',1

select @p1

exec [sys].sp_describe_first_result_set N'EXEC dbo.ETL_DATLOAD_SAVEBatch_Bandwidth',NULL,1

EXEC sys.sp_describe_first_result_set N'EXEC sp_who2'

SSIS 2012 is unable to generate the first result set when the stored procedure uses a temporary table. We need to provide the output result set as below to prevent the above error.

EXEC dbo.ETL_DATLOAD_SAVEBatch_Bandwidth

WITH RESULT SETS

(

       (

              BatchID int,

              LoadCount int,

              FailedCount int,

              SampleCount int,

              BadCustomerRows int,

              BadMediaRows int,

              FilePath varchar(500)

       )

)

Datetime Stamped Table Name

-- Variable that will contain the name of the table

   declare @mytable varchar(100)

   -- Creates a temp table name

   select @mytable = 'Table_' + CAST(DATEPART(yy, GETDATE()) as nvarchar(10)) + CAST(DATEPART(mm, GETDATE()) as nvarchar(10)) + CAST(DATEPART(dd, GETDATE()) as nvarchar(10))

   + CAST(DATEPART(hh, GETDATE()) as nvarchar(10)) + CAST(DATEPART(mi, GETDATE()) as nvarchar(10)) + CAST(DATEPART(ss, GETDATE()) as nvarchar(10))

   print @mytable

   -- Create the temporary table

   execute ('create table DatabaseName.dbo.'+ @mytable +

             '(

                           [Date] [datetime] NULL,

                           [CustomerId] [int] NULL

                           [Status] [tinyint] NULL,

                           [LastUpdate] [datetime] NULL

                     )' )

   -- Insert two rows in the table

   execute ('insert into  DatabaseName .dbo.' + @mytable +

                 ' ([Date]

           ,[CustomerId]

           ,[Status]

           ,[LastUpdate])

SELECT [Date]

      ,[FeatureId]

      ,[Status]

      ,[LastUpdate]

  FROM [dbo].[ Table ]')