Home Forums Data Warehousing Integration Services SSIS 2012 / mixed SQL Server 2008R2 and 2012 / stored procs which use #temp tables RE: SSIS 2012 / mixed SQL Server 2008R2 and 2012 / stored procs which use #temp tables

  • To fix the problem (for SS2012 only), use the following T-SQL instead:

    exec dbo.testProcWithTempTables

    with result sets((id int));

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.