Just encountered a frustrating error that prevented a new SSIS package from compiling and running. FTP Tasks had stubborn red crosses against them with the cryptic errors.
Error 1 Validation error. Delete C1 CTRL : Failed to lock variable “” for read access with error 0xC0010001 “The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.”. Blah.dtsx 0 0
Error 2 Validation error. Delete C1 CTRL : The Validate method on the task failed, and returned error code 0x80131500 (Failed to lock variable “” for read access with error 0xC0010001 “The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.”. ). The Validate method must succeed and indicate the result using an “out” parameter. Blah.dtsx 0 0
Error 3 Validation error. Delete C1 CTRL : There were errors during task validation. Blah.dtsx 0 0 What variable, “” doesn’t even exist so why are you trying to lock it!
As always, simple answer and my fault again, I had changed the FTP Task to use variables for source and destination paths, then changed the type to delete remote file. This left a hidden field that wanted a local path variable namethat wasn’t used but I’d told the task to use variables!
Changed the task back to a send files, changed local variables to false and then changed back to delete remote and all was well again.
So beware hidden variable fields. I’m guessing this will proabbly apply to most SSIS tasks that access paths such as File System Task etc.
Andy