September 10, 2018 at 8:09 am
Hi Team,
Problem:
I have a script task which has a variable and I am passing the variable to Data flow task as "Sqlcommand from variable".When I try to execute the package it has the below error.
Code: 0xC0014054 Source: Script Task-Sql Command Description: Failed to lock variable "User::latestFile" 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.". End Error Error: 2018-09-08 04:28:02.36 Code: 0x00000002 Source: Script Task-Sql Command Description: Failed to lock variable "User::latestFile" 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.". End Error DTExec:
Can some one shed some light??
Thanks
September 10, 2018 at 8:37 am
sathwik.em91 - Monday, September 10, 2018 8:09 AMHi Team,
Problem:
I have a script task which has a variable and I am passing the variable to Data flow task as "Sqlcommand from variable".When I try to execute the package it has the below error.Code: 0xC0014054 Source: Script Task-Sql Command Description: Failed to lock variable "User::latestFile" 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.". End Error Error: 2018-09-08 04:28:02.36 Code: 0x00000002 Source: Script Task-Sql Command Description: Failed to lock variable "User::latestFile" 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.". End Error DTExec:
Can some one shed some light??Thanks
Are you trying to set the value of the variable from within your script task? If so, have you added the variable to the read/write variables property of the script task?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply