Looking for a free, automated ETL tool to transform then load csv files into MsSQL table

[L Peal]

Hi,

The requirements are:
1. Tool must be completely free

2. Can transform dates and times in a csv file into a format acceptable to MySQL DateTime

3. Ability to set non-numeric data in a csv field to null

4. must be able to run in a cron script on Linux

5. The input csv file will be in a directory on the same server as the database. But I want to choose which directory according to a standard. In other words, I don't want to have to be forced to put the csv file in some odd location just to make the tool work.

I've already looked at clover and it looks like its not free. Checked into talend cost 13k per developer seat if automation is needed.

I didn't want to have to create a seperate all-string table just to be able to use MySQL Data infile. It looks like I may have to though. And then I'll have to write some kind of function to convert all the valid string-based data back into proper decimal form.

Your ideas and suggestions are greatly appreciated! I'm looking for something like Oracle SQLLoader which I really miss right now!