ETL and Data Integration tools - Modern ETL software for everyone

Help me please

I am trying to import a .csv file into a sql server table.

There is a date in the sql server table that I would like to populate
with the file creation date of the .csv file

How can I do this?

Craig

Are talking about visual importer ETL or Advanced ETL processor?

Peter

Visual Importer ETL

You are posted your question in wrong forum than.

any way set mapping type to calculated.
And use this expression.

GetSystemVariable('SOURCE_FILE_CREATION_DATE')

Please let us know the outcome

Peter

I am sorry for using forum.
Thank you for the assistance, it works as expected

Craig