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!\
Execute failed on statement INSERT INTO values (?, ? ,? ,?)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Tue Nov 02, 2010 2:36 pm
- Location: India
Execute failed on statement INSERT INTO values (?, ? ,? ,?)
Thank you,
Regards
Gowtham
(Learning DS)
Regards
Gowtham
(Learning DS)
-
- Participant
- Posts: 21
- Joined: Tue Nov 02, 2010 2:36 pm
- Location: India
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.
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.
Thank you,
Regards
Gowtham
(Learning DS)
Regards
Gowtham
(Learning DS)