DTSRun Error for user - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

DTSRun Error for user

Author

Topic

homebrew
Posting Yak Master

114 Posts

Posted - 2009-06-08 : 15:19:57

So, I'd like a user to run a Legacy DTS package via xp_cmdshell. I've created a test windows account with user rights for me to experiment with. I've set up a proxy account for the DTS permission, and given permission to xp_cmdshell. The account can run the DTS by opening it and executing, and can run xp_cmdshell, for example, this returns results with no error:

EXEC master.dbo.xp_cmdshell dir e:

But if I try to run the DTS via xp_cmdshell, I get errors:

DECLARE @strRun varchar (255), @List_ID int
set @List_ID = 999
SET @strRun = 'DTSRun /S "Server_Name" /N "My_DTS_Package"  /E'
SELECT @strRun
EXEC master.dbo.xp_cmdshell @strRun
Unhelpful Error:
DTSRun:  Loading...
DTSRun:  Executing...
DTSRun OnStart:  DTSStep_DTSDataPumpTask_1
DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
   
Error string:  Unspecified error
   
Error source:  Microsoft JET Database Engine
   
Help file: 
   
Help context:  5000000
Error Detail Records:
Error:  -2147467259 (80004005); Provider Error:  0 (0)
   
Error string:  Unspecified error
   
Error source:  Microsoft JET Database Engine
   
Help file: 
   
Help context:  5000000
DTSRun OnFinish:  DTSStep_DTSDataPumpTask_1
DTSRun:  Package execution complete.
NULL

Any thoughts ?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources