Using Variables

Variables are used to pass information between objects. For example, SQL script has failed and you would like to email the SQL to the developer. Insert <sql> Into email message and it will be replaced with actual SQL

There are several ways to create variables

  1. Using script action
  2. Using transformation action
  3. Using calculation object within transformation action
  4. Using Set Variable Action
  5. Using Global Variables

Predefined Variables List:

<username>
<computername>
<datetime>

<Project Name>
<Project ID>
<Package Name>
<Package ID>
<Package Item Log Name> <Current Package Item Name>
<Actual Execution Status>
<Execution Status>

<Main Package Log Name>
<Package Item Log Name>
<Rejected Records File Name>

<LAST EMAIL>

<QUEUE_ID>
<SuccessfulActionsCount>
<FailedActionsCount>

<CommonDocumentsDir>
<CommonAppDataDir>
<LocalAppDataDir>
<AppDataDir>

<Version>
<Repository Connection String>

Package Action Variables

Every Action has a predefined set of variables

Once action execution is completed values are assigned to enabled variables

Video Tutorials

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetle/packages/variables.txt
  • Last modified: 03/07/2019 04:16
  • by admin