ETL and Data Integration tools - Modern ETL software for everyone

Hello


I’m having a number of issues at the moment getting imports to work.

Issue 1

I have 3 imports that I have put into a package.

The first runs fine which is direct path, the other 2 do not which are conventional path as I was using some functions [incidentally the system date does not work]

For the 2 that don’t insert the before sql gets executed that does a delete, but no new records are created.

All 3 imports work fine on their own [except for the sysdate function] if run individually.

Issue 2

I am doing an update that is based on a select statement. This is basically doing a FK update. Again this is conventional path

I am getting an error

Could not connect to oracle database: ORA-12560: TNS protocol adaptor error

This is the same connection that works for the imports.

Thanks



Dave.

David

Regarding issue N1

1 Is there any errors in the package log?
Click help -> Email Repository and log files to Support

2 incidentally the system date does not work
Can you email us a screen shot showing how you set it up

3 What version have you got?

It would be great if we can connect to it remotely and have a look at it ourself

Mike,
DB Software Laboratory