asked on

Issue with SSIS package running in task scheduler on WIndows 2016 with SQL 2016

We have an SSIS package configured to run from Task Scheduler. When you are logged into the server as the user which has rights to run the package, it will run manually and as scheduled. When you logout it will run, but threw a Last Run Result of 0x1 and never execute the package. The task is set to Run whether user is logged in or not. User that runs the package is a local admin so it should be able to Log on as a Batch. Not sure what I'm missing, but it seems like its some sort of permission issue. Any guidance would be appreciated.

Deepak Chauhan

Please try to reschedule the package in Windows task scheduler using Create Task wizard and check. Ignore Create basic task wizard.

Also you can schedule the SSIS package in SQL agent job instead of Windows scheduler if you have licensed version of SQL Server.

TPBPIT

ASKER

I recreated the task as described above, scheduled it to run and left task scheduler open while still logged in as the user that run the task and at the next run got a 0x1 for the Last Run Result. So recreated the task didn't change anything.

EugeneZ

try to wrap your code into BAt file ( unless you did already)
and select " run when user loged on or not " in the task manager "general tabl

please check "step-by-step" example
Schedule SSIS Package Without Deploying By nirav
http://nirav.extreme-advice.com/2013/05/08/schedule-ssis-package-without-deploying/

ASKER CERTIFIED SOLUTION

TPBPIT

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TPBPIT

ASKER

Because we fixed our own issue and it wasn't anything recommended by that other participants.