How To Pass Filename From Package To Transformer

Pass the current file name from workflow logic into transformation logic.

Advanced ETL Processor
4.9 ★★★★★ Based on 16 reviews on Capterra See all reviews on Capterra →

This tutorial demonstrates how to pass a filename from a package to a transformer using global variables.

What You Will Learn

  • Understand when to use Pass Filename From Package To Transformer.
  • Configure the key Advanced ETL Processor objects used in the workflow.
  • Run the workflow and check the generated output.
  • Use the same pattern in scheduled or repeatable automation jobs.

Before You Start

Open the sample workflow or prepare a small test file before applying the pattern to production data. It is easier to fix a test file than a Monday morning reporting run.

Need Advanced ETL Processor First?

Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.