Post reply

Error while executin xp_cmdshell

  • November 14, 2006 at 1:44 pm

    #193164

     

    Hi,

     

    When I execute the following command:

    exec master.. xp_cmdshell 'dtsrun /S Server name/N packagename  /E'

    I am getting following.

    DTSRun: Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not been called.

    Please help me in above.Thanks in advance

    Usha

     

  • November 15, 2006 at 11:41 am

    #672082

    could it be related to the similar issue found here?:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=110704

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 15, 2006 at 1:29 pm

    #672120

    Thanks for your reply.I tried re-starting SQL Server Agent.But the issue is  not yet fixed.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply