ETL and Data Integration tools - Modern ETL software for everyone

Hello forum

I am getting nothing is mapped error in the execution log

What does it mean?

Kite

Have actually mapped source fields to target?

If you double click on the transformation can you see red lines connecting source and target fields?

Mike

I see what you mean now.
Completed ETL transformation mapping, but no data is being loaded.
What am I doing wrong?

Kite

This might happen when your target database is MS SQL server and batch size is set to 0, in this case entire load is treated as one transaction and if there we any foreign key or pk violations the entire load will be rolled back so you will not have any records.
Try setting batch size to 1 and check the log afterward

Mike

New licensee here...
I am experiencing this problem when trying to transfer data from MS SQL to SQLite. I have some existing packages/transformations that get data from MS SQL to MySql and these seem to be working ok. When I try to do this with SQLite I open the Transformer object and there are no table fields to map to on the SQLite side. Any clues or an RTFM slap would be much appreciated.

Ron

a Can you answer the following questions please

1 Can you see the table names?
2 when you open data writer properties on the first tab
Have you selected the conenction name?
3 Is the the last transformer before writer?

a copy you sql lite database into c:\support directory
make sure that conenction is pointing into this directory
make sure that writer is pointing into this directory
Save everthing

Email us your repository and c:\support directory together with sqlite database
Let us know the transformation name you are having problems with

Peter