Could not load package "XX-SSIS-XX" No description found

0

I'm trying to run a ssis package on a remote integration server using dtutil which is being called within a stored procedure using cmdshell. I now this isn't the best way to run a ssis package but its what I have inherited. So doing a new deployment to a fresh new server I've created a proxy account for the cmdshell to run under, which isn't an admin account on the domain. I have run the following scripts on my sql box

GRANT EXECUTE ON xp_cmdshell TO [domain\Account which will call the SP which runs the cmdshell];
EXEC sp_xp_cmdshell_proxy_account null
EXEC sp_xp_cmdshell_proxy_account 'domain\non admin account which the cmdshell will run as','xxxxxxx'

The code within the SP

select @DtexecParams = 'dtexec /sq xxSSIS Packagexx /ser xxremoteserver where the package isxx'
--
-- I set other connections and local parameters the package uses
-- 
exec @rc = xp_cmdshell @DtexecParams

Now on the remote server where the package is located I've added the domain account that the cmdshell proxy is using as a ssis operator and a datareader on the msdb database. But when i'm running the SP to call the package I'm getting the following error returned

Could not load package "xxxxxxxx" because of error 0x80131534. Description: No description found Source:

This does not tell me much but when I run the sp as a sysadmin user all works fine, so it is more likely to be a permission issue. I've added the proxy account user to local policy "Log on as batch job", but I still get the error.

sql-server-2012
ssis
ssis-2012
asked on Stack Overflow Oct 2, 2014 by 1plus1equals10 • edited Oct 2, 2014 by billinkc

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0