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. ".

enter image description here

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

.

+3


source to share





All Articles