ETL and Data Integration tools - Modern ETL software for everyone

Hi Mike

I have a question please concerning the setting up of the CSV export file names that currently are created from the extract runs.

I have built an output format that utilises input from a Set Variables object and also the Package variable <datetime> variable.

The requirement is to enable the 25 CSV files from each Extract run to be placed into a folder whose name matches the day of the month
– The CSV files for the extract that takes place at 03:00 on the 3rd of Jan will end up in a folder E:\ETL\MY_L03 – there are 31 folders set up:

The actual file name generated is as follows – MY_CheckLog20110113030106

As shown before the <datetime> Package variable generates an entry as yyyymmddhhmmss

MY_CheckLog20110113030106

What I have been trying to do is effectively cut back the <datetime> to just yyyymmdd

I have tried using a LeftString function but it does not work – do you of an approach that could prove the reduced file name?

Thank you for your assistance – we have now had a couple of day’s successful extract operating under the control of the Scheduler.

Regards,
Thomas

Use different function

FormatDateTime('yyyymmdd',now)

Mike