ETL and Data Integration tools - Modern ETL software for everyone

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 ?

Although it is possible to achieve that by using calculation object it would be very slow.
Reader parameter object is more appropriate but it can't do it at the moment.
We will modify it for you and let you know when it is ready.

It will take 2-3 days.

Peter

I am not sure what you are proposing, however this is what I am trying to do.

Based on a file retreived from an ftp site, I am inporting the .csv into a sql server table

One of the sql server feilds is a date, which is not contained in the file, but rather the file creation date of the file itself

There are multiple files that are processed each day and the files can come in over several days, making the date on the file quite important

There are about 100 files to be processed every day

The product that I am trying to use is Visual Importer Enterprise Version: 7.7.7.2

Thanks

Download and install version

7.7.7.3

Support for MS SQL Server Compact Edition was introduced
Calculations Enhancements
Various bugs fixes

Set your mapping type to calculated

and use this formula

GetSystemVariable('SOURCE_FILE_CREATION_DATE')

Please let us know the outcome,
Mike

When I import the file with the date of 03-APR-2011 the only format that I seem to ge able to use that will populate into the sql server table that I have defined (as a datetime feild) is DDMMYYYY, however this returns 20-NOV-2011 in the database table.

Please advise what I am doing wrong.

Thanks