May 14, 2018 at 4:08 pm
I created a SSIS package to rebuild indexes on my database, but when i run the package in a scheduled job i got following error message. Rebuild Index: Error: Failed to lock variable "RunID" for read access with error 0xc0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the variable 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."". No Idea why i am getting this error. Please can someone help.
May 14, 2018 at 4:29 pm
You need to give a lot more details here. We have no idea what your package is doing, however, I'd guess you have a script task in there. Help us help you; we can't access your package so tell us about it. Post the code from the script, what the properties of it are, etc etc etc.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 7:41 pm
No i didn't used any script task. I just used Rebuild Index task and Reorganize task in control flow with respective connections and Database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply