Home Forums SQL Server 2005 SQL Server 2005 Integration Services DTEXEC returning Exit Code 5 RE: DTEXEC returning Exit Code 5

  • April 1, 2014 at 5:51 pm

    #1702293

    Scott Nicholson-254313 (4/1/2014)

    1. This package is on-demand execution triggered from an application. Setting it as a job won't work.

    2. I am sysadmin on the server. The users will be activating the process. This is the main issue.

    3. Will a proxy fix this issue? I have used the login context before with other applications, and they are functioning correctly.

    It could fix it .. First create the server proxy account (SSMS --> SQL Server Properties --> Security )

    Check this

    http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx

    --

    SQLBuddy