none
Failed to acquire connection tempdb RRS feed

  • Question

  • Hi, I have an SSIS project, has a connection to tempdb (local sql2k5 server), 3 tasks, creating a table, populating the table, then deleting the table. of course when I test the connection i GET TEST Succesfull (I amusing sa ...)

    Whenever I run the package, all tasks become red colored indicating, I get the following error :
    ---------------------------------------------------------------------------------------------------------------------------
    [Execute SQL Task] Error: Failed to acquire connection "tempdb".
    connection may not be configured correctly or you may not have the right permissions on this connection.vance
    ----------------------------------------------------------------------------------------------------------------------------
    Any help would be appreciated. Thanks in advance

    Sunday, January 22, 2006 9:39 AM

All replies