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
See if it complains also about sa's password when package executes.
No comments:
Post a Comment