Post reply

problem in executing ssis package through a job

  • August 13, 2007 at 3:10 pm

    #153740

    Hello,

                I have a SSSIS package which consists of "execute process task' it fetches a cmd executable from a location and executes it.The problem Iam having is when i execute this package using business intelligence studio  it executes perfectly,but when I try to execute this through a job it just goes in loop .The package does not execute at all[the job just keeps running] nor do I get an error message.

     

    does anybody else experienced the same problem.

     

    Thanks

  • August 16, 2007 at 2:09 pm

    #727485

    When you run from within BIDS, you are running the package with your account.  The job uses (by default) the SQL Agent Service Account.  Make sure the service account has the appropriate permissions to run the exe you are attempting to run.

    Another option (which I don't like for security reasons, but your opinion may be different) is to set up a proxy account in SQL Server and use that in the job step.

    Hope this helps.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply