|
|
You're in the
sql server dts
group:ERROR: Need to run the object to perform this operation
sql server dts:
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
No, It actually returns the sever name. Any other
thoughts... Sandeep [quoted text, click to view] >-----Original Message-----
>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@discussions.microsoft.com> wrote in message >news:b05601c3ecbb$130d3ce0$a101280a@phx.gbl... >> 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 > > >.
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 [quoted text, click to view] >-----Original Message-----
>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@discussions.microsoft.com> wrote in message >news:b41d01c3ecc1$039f9860$a301280a@phx.gbl... >> No, It actually returns the sever name. Any other >> thoughts... >> >> Sandeep >> >> >-----Original Message----- >> >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@discussions.microsoft.com> wrote in >> message >> >news:b05601c3ecbb$130d3ce0$a101280a@phx.gbl... >> >> 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 [quoted text, click to view] "Sammy" <anonymous@discussions.microsoft.com> wrote in message news:b05601c3ecbb$130d3ce0$a101280a@phx.gbl... > 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
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 [quoted text, click to view] "Sammy" <anonymous@discussions.microsoft.com> wrote in message news:b41d01c3ecc1$039f9860$a301280a@phx.gbl... > No, It actually returns the sever name. Any other > thoughts... > > Sandeep > > >-----Original Message----- > >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@discussions.microsoft.com> wrote in > message > >news:b05601c3ecbb$130d3ce0$a101280a@phx.gbl... > >> 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 > > > > > >. > >
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 [quoted text, click to view] "Sammy" <anonymous@discussions.microsoft.com> wrote in message news:b45a01c3ecc4$de779570$a301280a@phx.gbl... > 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 > > >-----Original Message----- > >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@discussions.microsoft.com> wrote in > message > >news:b41d01c3ecc1$039f9860$a301280a@phx.gbl... > >> No, It actually returns the sever name. Any other > >> thoughts... > >> > >> Sandeep > >> > >> >-----Original Message----- > >> >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@discussions.microsoft.com> wrote in > >> message > >> >news:b05601c3ecbb$130d3ce0$a101280a@phx.gbl... > >> >> 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 > >> > > >> > > >> >. > >> > > > > > > >. > >
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??? [quoted text, click to view] >-----Original Message-----
>No, It actually returns the sever name. Any other >thoughts... > >Sandeep > >>-----Original Message----- >>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@discussions.microsoft.com> wrote in >message >>news:b05601c3ecbb$130d3ce0$a101280a@phx.gbl... >>> 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 >> >> >>. >> >.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |