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