DTSRun: Cannot create COM Server to load and execute DTS Package

• Bikeman

  Ten Centuries

  Points: 1207

  More actions

  February 20, 2005 at 11:05 am

  #163357

  Hi all,

  I don't see DTS forum for sql 2000, so I'll post here. I'm trying to exec DTS package from stored proc using xp_cmdshell and dtsrun. My proc:

  alter procedure dtsrun_test as

  declare @result int

  exec @result = master.dbo.xp_cmdshell 'dtsrun /E /SMyServer /N''test_dtsrun'''

  if (@result = 0)

  print 'SUCCESS!'

  ELSE

  print 'FAILURE'

   

  I get an error:

  DTSRun:  Cannot create COM Server to load and execute DTS Package.  Error -2147024769 (8007007F):  The specified procedure could not be found.

  I checked that SQLAgent is running under this system account, just like SQLServer (this is local stand alone machine). I tried everything, eve sa username and password, nothing works.

  I can execute package manually fine, but not from sp.

   

• bimal

  Valued Member

  Points: 74

  More actions

  February 21, 2005 at 2:48 am

  #543283

  Try using

  exec @result = master.dbo.xp_cmdshell 'dtsrun /E /SMyServer /Ntest_dtsrun'

   

• Bikeman

  Ten Centuries

  Points: 1207

  More actions

  February 21, 2005 at 2:40 pm

  #543370

  didn't work.

  I even tried:

  master..xp_cmdshell 'DTSRUN /S "MyServer" /E /N "test_dtsrun"'

  with same results.

• Bikeman

  Ten Centuries

  Points: 1207

  More actions

  February 21, 2005 at 3:08 pm

  #543372

  my dtsrun utility was simply corrupt. I just ran it on a different server fine, with no problem. The dll entry point was the problem on this machine

  violla

• sandeep kumar-299988

  Grasshopper

  Points: 14

  More actions

  May 2, 2008 at 11:46 pm

  #810401

  Hi ,

  I am also experiencing the same problem , could you explain me the pointing problem and what's need to be done.

  Thanks