ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I am evaluating Visual Importer Enterprise. I downloaded the software and I am trying to perform an insert from a csv file into a database (MS-SQL) table. Does the evaluation copy have any restrictions on the number of the records and/or the number of fields it can import? If so, how do I evaluate full functionality before deciding to purchase?

Thanks.
Ramesh

No, there are no limitations

Are you having any difficulties?

Mike

Sorry, I meant to say "import" instead of "insert".
Yes, I am having some problems.
The csv file has headers for each column on the first line.
The table that I am importing into also has the same column names, the imported maps only the first 4 columns, I seem to have to match the rest of the columns by manually.
Does this sound correct?

Also on import of each record I have to calculate a column value for each row, but I require some reasonably complex Date functions such as DateDiff, DateAdd etc. Are these functions available?

I also have to automate a daily import where the data file has the following format "TMP-YYYY-MM-DD.txt", how do I tell the importer the filename to import if it changes every day?

Thanks.
Ramesh

1

Sorry, I meant to say "import" instead of "insert". Yes, I am having
some problems. The csv file has headers for each column on the first
line. The table that I am importing into also has the same column names,
the imported maps only the first 4 columns, I seem to have to match the
rest of the columns by manually. Does this sound correct?


click Set First Line As Field's Names
than click Auto map data

2

Also on import of each record I have to calculate a column value for
each row, but I require some reasonably complex Date functions such as
DateDiff, DateAdd etc. Are these functions available?

Have a look at calculations in documentation if something is missing we can add it for you

3

I also have to automate a daily import where the data file has the
following format "TMP-YYYY-MM-DD.txt", how do I tell the importer the
filename to import if it changes every day? Thanks.


You may use mask to load files

TMP-*.txt

Have a look at these online tutorials

www.dbsoftlab.com/Visual-Importer/How-to...Server-Database.html
www.dbsoftlab.com/Visual-Importer/How-to...al-Importer-ETL.html

hope that helps
Mike