Run sql server agent job task in ssis error: Failed to lock variable "RunIs" for read access with error 0xC0010001
I am using SQL Server 2016
and SSIS
. I have a package where I call the sql server to work.
My job has just one step how PowerShell command
to transfer all files from one directory to another directory between two servers.
When I run my job from SQL Server it works well.
When I run my package from VisualStudio
, everything is fine, but after deploying my project to sql server, when I want to run this package from SQL Server, I have this error:
SQL Server Agent Job Task Execution: Error: Failed to lock variable 'RunId' for read access with error 0xC0010001 "Variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variable collection on a container during batch execution and the variable does not exist . The variable name can be changed or the variable is not created. ".
I removed Execute sql server agent job task
from my package and I redeployed my project and now I don't have this error. It is clear what the error is Execute sql server agent job task
.
I have over 2000 files in my source directory and it takes a few minutes to transfer all files to the destination directory.
Edit1 : I have several tasks and components in the package, and the last ones Execute sql server agent job task
and I don't Execute T-SQL Statement Task
.
source to share
No one has answered this question yet
See similar questions:
or similar: