Post reply

Failure in Destination for Temporary double-hash (##) table in SSIS

  • March 13, 2012 at 4:53 am

    #257368

    Hi All,

    I want to redirect rejected records to a temparary double-hash (##) table eg. ##Temp_Tbl_Nm. But every time the Destination for rejected table is failed. Error message is DTS_E_OLEDBERROR "Invalid object name '##Temp_Tbl_Nm' ".

    Please help....

  • March 13, 2012 at 6:34 am

    #1458417

    I guess you create the temp table in another task?

    You need to set the property RetainSameConnection of the connection manager to TRUE.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 14, 2012 at 9:55 am

    #1459318

    Thanks now its working.... 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply