Where I wrote:

"I haven't been able to get the job to call a SSIS package that calls the batch file (using an Execute Process task) under the Service Account credentials. The job always hangs."

What I should have said is that I have reduced the batch file that the SQL Server Service Account is attempting to run to just these lines:

pushd "\\myServer\myShare"

dir *.csv > Test_file.txt

popd

Even with the batch file reduced to just this, the job hangs when calling a package that calls this batch file using the Execute Process task, using the Service Account's credentials.

I wish it were easier to fix permissions issues using the SQL Server Service Account in SQL Server.

Thanks,