Post reply

SSIS - external table is not in the expected format

  • February 24, 2012 at 12:42 pm

    #265225

    I have a daily "excel" file that I need to import into SQL server. When I open the excel file it's actually a single file web page. So the Excel Source isn't working. Is there a way to use SSIS to change the file from Single File Web Page to an xls file?

    Thanks

  • April 12, 2012 at 2:14 pm

    #1472939

    I am having almost the same issue our files came with .xls extensions but in reality they are web page (html) files. If I open them with Excel and do a save as and change type from Web page to Excel Workbook everything works fine. I am still looking and will share if I find something

  • April 16, 2012 at 7:28 am

    #1474017

    the question is really "I have an HTML source, how do I put it into a table?"

    Excel is a red herring, it just opens everything 🙂

    I think you can do this by writing a style sheet and then using XML tasks, one from HTML to a string variable (that stores the XML results) and another from the XML to a table

    I've done it in reverse that way

    writing a style sheet can be fiddly

    someone has asked it here

    http://social.msdn.microsoft.com/Forums/en-us/sqlintegrationservices/thread/5b75328f-1a50-4fe4-bb43-64c8f214f91e

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply