ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I have a simple transformation loading data from my source file to my target table. I would like to load the file name from my source file to my target table as well.

I believe I need to utilize the Function ExtractFileName within a Calculation Transformation Object. What would my variables be and what would the variable types be? Should there be a field from my Validator going into the Calculation Transformation Object?

I’m confused. Could you please show me how to accomplish this?

Thanks
Steve

That is simple

Use Data Reader Parameter transformation function


Mike