Running .bat file in SSIS package

  • Thanks for helping !

  • Hi All,

    I got similar issue where I need to run a Batch file which is pinned to a SSIS package - Execute task and I pass some parameters to the batch file. It was running fine when I manually run in visual studio but hung when I ran through sql job.

    I figured out this is a permissions issue, all you need to make sure is your sql agent service account needs read/execute permission on the batch file that you are executing using ssis. This reslved my issue. Hopefully this helps you.

    Good luck.

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

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