DSXchange

Hi,

I am trying to connect to oracle database as source or target. But I am not succeeded in that.

I created a sample job where I want to read data from a file and load it into database using ODBC connection.

Here are the steps which I did:

1. Created ODBC connection
2. Created sequential file table definition
3. Created new job
4. Used Sequential file stage and defined all properties
5. Used ODBC connectionPX stage
6. Defined properties
7. Compiled successfully.

When I run the job, a new table is created. Data is being imported from the sequential file. But during insertion into database an error occurred which is as follows:

"TUTORIAL_3,0: [IIS-CONN-ODBC-000016] Execute failed on statement INSERT INTO
Sales_Data.Load_Target ( Region_ID , City , Zone_Id , Regional_Sales )
VALUES
(? ,? ,? ,? )"

Any help is appreciated.

Thanks a lot!\

Thanks a lot friends.

Within minutes I posted my problem to DSXCHANGE, my problem got solved which is not being solved for 2 days.

I found that, some how the table name is wrongly updated in the statements. Now I updated the query manually. Its working fine now.

But I am having the same problem, even though I've checked each and everything is correct.

Please any help.

Jack, please start your own thread with your details rather than jumping oh here and saying you have the "same problem". That will go a long ways towards getting your problem solved.