Insert Excel data to oracle tables using OLEDB
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-11-22 09:43 AM
Hi,
I am trying to insert data from an excel file to oracle table using OLEDB.
Since the data in the excel in large count (100000+), the insert fails.
Can someone help me with this ?
10 REPLIES 10
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
20-12-22 04:58 PM
Can you also check the work queue is creating your work items correctly and are showing as pending? also check that the criteria you have set for Get Next Item will return a pending item from the queue. The only way I could recreate a similar issue to yours is by setting the criteria on the get next item incorrectly so that the Get Next Item failed.

- « Previous
-
- 1
- 2
- Next »