SSIS - Errors when running a package . dtsx

Asked

Viewed 335 times

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 the Show 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&#xA; DTS:Name="SQLFolder">@[$Package::CARGA_ST_SQLFolder]</DTS:PropertyExpression>

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.