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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply