We are having a very strange error since past few days. We
have a batch file that executes 20 some DTS packages on
nightly basis. But since past few days we are having the
following error on (one specific) DTS package

Error = -2147221499 (80040005) Error string: Need to
run the object to perform this operation Error source:
Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 1100Error Detail
Records:Error: -2147221499 (80040005); Provider Error: 0
(0)

On the contrary, if you try to run that individual DTS
package seperately, there is no error and it runs fine. I
searched for this error and found that my server name is
unnamed. I am hesitant of running
( sp_dropserver 'servername'
go
sp_addserver 'servername', local
).

Has anyone seen this type of behavior before? Any help
will be appreciated.

TIA

Sammy

80040005

suggests an authentication / permissions problem.

On the server if you do


SELECT @@servername do you get NULL?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sammy" <anonymous (AT) discussions (DOT) microsoft.com> wrote

No, It actually returns the sever name. Any other
thoughts...

Sandeep

What did you mean in your original mail "my server is unnamed"

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sammy" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I googled around and found this KB article.

http://www.dbforums.com/t502581.html
http://support.microsoft.com/default.aspx?scid=kb;en-
us;q268413

This is where it describes the problem leading to unnamed
server.

thanks,
Sammy

And that was one of my recommendations in that thread.

It does mention the @@servername returning NULL though which you said was
not true of your situation.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sammy" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Did anyone find a resolution to this... I am having a very
similiar problem. However, I find that if I run the DTS
Package through Enterprise Manager... it works fine... If
I schedule it to run or run it throught the DTS Utility or
command prompt... it fails with the -2147221499 error???