I'm running a package that has 2 variables to run a date filter and when it runs it works correctly, but it pops up the following errors:
-> Error: Attempt to parse the expression "@[$Package::CARGA_ST_SQLFolder]" failed and returned
error code 0xC00470A6. The expression cannot be parsed. It might contain invalid elements or it might
not be well-formed. There may also be an out-of-memory error.
-> Error: The expression "@[$Package::CARGA_ST_SQLFolder]" on property
"\Package.Properties[SQLFolder]" cannot be evaluated. Modify the expression to be valid.
-> Error: The variable "$Package::CARGA_ST_SQLFolder" was not found in the Variables collection.
The variable might not exist in the correct scope.
-
I do not have the slightest idea of what this variable is
$Package::CARGA_ST_SQLFolder, I've never created it. And I was not able to find it, even seeing the variables with% active%. -
The cases I encountered with these errors on the internet all talked about variables with the package scope trying to set a value for a project variable, which is not the case here. In my case it is the opposite, the result of the project variable that arrows a value in the package variable ...
-
I also tried converting the package connections using
Show system variables, but it did not work ... The same error always continues. -
I tested only with variables from the package itself and the same error continues. So this confirms that the problem is not the scope of the variables.
I want to know what's causing this error and how to fix it.
~ Edit
-
I can run and everything works, despite the errors, in debug mode, but when trying to execute via bat these errors are impeditive to continue the execution of the package.
-
I'm starting to think it was some lost configuration that's causing this, but I can not figure out what or what it is
-
The name of the variable that is described in the error log is
Convert to Project Connectionand I was not the one who created this variable and can not find it anywhere.