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

  • Hi MM

    The error occurs when you use the proc in an OLEDB Source, within a data flow. ExecuteSQL tasks are not affected, as far as I know.

    I did this, using your proc. Then, after clicking on 'Columns', the meta data error is displayed, as per the attached screen shot.