1
I am running a package that has 2 variables to run a date filter and when running it it works properly, but it bursts 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 have no idea what that variable is
$Package::CARGA_ST_SQLFolder
, I never created it. And I couldn’t find it, even seeing in the variables with theShow system variables
active.The cases I found with these errors on the internet all talked about variables with the scope of the package trying to set a value for a project variable, which does not happen here. In my case it is the opposite, the result of the project variable that arrow a value in the package variable...
I also tested converting the package connections using the
Convert to Project Connection
, but it didn’t work... The same mistake always continues.I tested only with variables of 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 is causing this error and how to solve the problem.
~Edit
I can run and everything works, despite errors, in debug mode, but when trying to run via bat these errors are preventing to continue the package execution.
I’m beginning to think that it was some lost configuration that’s causing this, but I can’t figure out which or what it is
The name of the variable that is described in the error log is
$Package::<NOME_DO_PACOTE>_SQLFolder
and I’m not the one who created this variable and I can’t find it anywhere.
I have no idea what it was, how it was created, why it was breaking or anything. But I opened the XML and deleted the tag I found with that name of the bug and everything came back to work!! The tag is this:
<DTS:PropertyExpression
 DTS:Name="SQLFolder">@[$Package::CARGA_ST_SQLFolder]</DTS:PropertyExpression>
– Andrey Hartung