Hello,
I am trying to process a MIME HTML (MHTML) file with .XLS extension using an unstructured data stage and it is not being recognized as a valid excel file. The file is getting processed successfully if I manually save it as an excel file. Can I use any other stage in DataStage to process the MHTML file directly without manually converting it into an excel file? I have to automate the load process without any manual intervention. Thank you in advance.
Loading MHTML/XLS file using Unstructured Data stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
I'm not aware of any such stage out of the box, but DataStage does permit you to write your own custom stage types, so that may be an avenue to explore if you are comfortable with the C++ programming language. (Otherwise you could hire someone to do that work for you.)
I'm not aware of any such stage out of the box, but DataStage does permit you to write your own custom stage types, so that may be an avenue to explore if you are comfortable with the C++ programming language. (Otherwise you could hire someone to do that work for you.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.