I have schedule to run SSIS package which contains multiple script tasks using a console application and task scheduler.
Task scheduler hits ssis package and packages executing successfully when user logged in azure VM where everything setup.
When user logged out from VM and schedule time arrives package failing. But this is happing on only Azure VM. My Local VM which is on Hyper-V, It is executing successfully whether user is logged in or not. Everything is same on both environment and both environment configured same way.
Below are the log error...
3/23/2023 3:00:20 PM Prepare Cancellation Report Csv:Error: Failed to compiled
scripts contained in the package. Open the package in SSIS
Designer and resolve the compilation errors.
`3/23/2023 3:00:20 PM Prepare Cancellation Report Csv:Error: MSB4018 - The
"GenerateResource" task failed unexpectedly.
System.Runtime.InteropServices.COMException
(0x8000FFFF): Catastrophic failure (Exception from
HRESULT: 0x8000FFFF (E_UNEXPECTED))
at IInternetSecurityManager.MapUrlToZone(String
pwszUrl, Int32& pdwZone, Int32 dwFlags)
at Microsoft.Build.Tasks.GenerateResource.IsDangerous
(String filename)
at Microsoft.Build.Tasks.GenerateResource.Execute()
at
Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Buil
d.BackEnd.ITaskExecutionHost.Execute()
at
Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiated
Task>d__26.MoveNext(), C:\Windows\Microsoft.NET
\Framework64\v4.0.30319\Microsoft.Common.targets, `
2318, 5
3/23/2023 3:00:20 PM Prepare Cancellation Report Csv:Error: The binary code for
the script is not found. Please open the script in the
designer by clicking Edit Script button and make sure it
builds successfully.
and more...
Package failing only when user not logged in and only on azure VM.
If someone already faced this issue please guide me.
Thanks.
I have tried multiple time on both environment one is azure VM and another is my own VM on Hyper-V.
Observed that ssis package running successfully on Local VM whether user logged in or not and doing intended work.
But on Azure Environment same ssis package with same configuration running successfully when user is logged in system (VM), whether executing manually or on schedule time arrive.
And failing on schedule when user logged out.
