Home Forums Article Discussions Article Discussions by Author Discuss content posted by Michael Cape SSIS and Stored procedures using temp tables RE: SSIS and Stored procedures using temp tables

  • October 22, 2013 at 6:20 pm

    #1660766

    The answer (in SQL 2012) is to use the 'WITH RESULT SETS' option on the EXEC statement.

    See http://technet.microsoft.com/en-us/library/ms188332.aspx for specifics.

    Rob Schripsema
    Propack, Inc.