Hi guys!
I'm having troubles trying to import an excel file saved as XML.
Tried XML Source, Excel Source, OLEDB Source with no success.
Could someone point me to the right direction?
Thanks in advance.
I cannot see how you would do it without a custom script component as a source which opens the file with Excel automation (Not ideal).You could (maybe) create your own XSD to allow SSIS to understand the document and create proper column / rows for you but you might end up doing a lot for nothing.
Can you not get it as a normal XLS file?
No comments:
Post a Comment