Home Forums Data Warehousing Integration Services SSIS: Calling dtsx using xp_cmdshell in SQL Server 2008- error on task - with Execute Process Task (error: "No process is associated with this object) RE: SSIS: Calling dtsx using xp_cmdshell in SQL Server 2008- error on task - with Execute Process Task (error: "No process is associated with this object)
Elliott Whitlow
SSC Guru
Points: 102296
More actions
December 20, 2013 at 4:58 pm
#1675340
What is the difference in permissions between the SQL Server and the user running it at the command line? I'm guessing that the working directory may not allowed for the the SQL Server. Does SQL run as a user with administrator rights or not?
CEWII