ETL and Data Integration tools - Modern ETL software for everyone

Help me please.

Vimp will not import.

Source db is an Oracle db. Target is a MS-SQL db.
The source records are displayed correctly.
The target DB user has all permissions to read / write in the table. I
don't know where to look any more.

Kind regards,

G.W.

Hi.

Have you got any messages in error log?
All you fields are set to

IfNull=Ignore
IfError=Set To Null

Set if error to reject.

May be some of calculations are not working
There are some examples in documentation.

Plus watch those videos they will help you to get started

www.dbsoftlab.com/Documentation/A-Quick-...al-Importer-ETL.html

Mike

I don't even get any message in errorlog. It just won't start. The
Check Script doesn't give any error.

I tried it with a source data coming from only one table (SYSADM.ORU),
using Select Table instead of SQL statement. It works, but the R_TEXT
field content is not displayed. The source database is Oracle and the
field is defined as LONG RAW.
It looks like the SQL statement gets the data from the source database
all right but it cannot pass them through to the target database.

Does it make any sense to you?

Kind regards,
G.W.

It could be problem with your source or target.

Can you try loading from small text file into different table.

If it works try different source table

Also how big is your source table?

We can also do some testing on our site.

Can you email us tables creation scripts
Mike

It could be problem with your source or target.
>If it doesn't rain it will be dry

Can you try loading from small text file into different table.
>It works

If it works try different source table
Will do next week

Also how big is your source table?
>>The table is huge, but I select only 100 records. But maybe i just am kind of impatient. Next week i'll give it more >>time.

We can also do some testing on our site.
>>You could also connect to my computer using TeamViewer4

Can you email us tables creation scripts
>>Bit tricky

G.W.

The table is huge, but I select only 100 records. But maybe i just am kind of impatient. Next week i'll give it more time.

Fist thing we d,o we count the number of records in source table if table is huge it might take a while

Mike