June 3, 2009 at 2:48 pm
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 ?
June 4, 2009 at 3:47 am
Did you try to log in to the sqlserver machine with the proxy account and run dtsrun directly from cmd prompt? It could also depend on env variables.
-- Gianluca Sartori
June 4, 2009 at 7:42 am
I didn't try that. Would a user be able to use the command prompt ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply