Advanced ETL - Transformation Editor Set Package Variable

How do I properly use the "Set Package Variable" action in the transformation editor?
A simple example: I've set up a sequence to count all the rows in the source and place that in a #COUNT# variable.
If I use the "Set Variable" action, it works perfectly, but I can't retrieve the variable in another package action. But, using the "Set Package Variable" slows down the processing by a lot.
Is there a way to set a transformation action to only run once at the end of the transformation? Or maybe use a script after the transformer and before the writer to set a global package variable from the local variable?
 

Also, what is the "Count Number of Records" option for Oracle and Sql sources? Does it store that in a variable I can access? This won't solve all the counting requirements I have as I will do counts by groups and calculations as well, but it can help with a simple "count all records" requirement.
 

Regarding "Count Number of Records"
When you run a transformation, Advanced ETL Processor displays a progress bar and completion percentage.

To calculate this percentage, the software must first determine the total number of records in the source table.This record-counting operation can take a significant amount of time, especially for large tables, and may negatively impact overall performance.

Disabling Count Number of Records prevents the software from counting the records before processing begins, allowing the transformation to start immediately and potentially improving performance.
 

Set Package Variable works with all data sources, not just SQL databases.At the moment, there is no "Set Once at the End" option available. The variable is updated each time the action is executed during processing. 

Since you are working with SQL server there is more options available

www.etl-tools.com/wiki/advanced-etl-proc...to-variables-action/

or

www.etl-tools.com/wiki/advanced-etl-proc...to-variables-action/



Any more questions let me know