Post reply

excel destination editor error

  • September 27, 2010 at 9:50 am

    #227082

    Hi,

    I made a SSIS package with the purpose of populating the excel sheets by a table output from the sql server.

    In the data flow task, I have made 2 tasks namely OLEDB source and other is excel destination.

    In the edit options of excel destination, i have chosen excel connection manager as the OLEDB connection manager and in data access mode : table or view.

    When I try to click the name of the excel sheet, I get the error:

    external table is not in expected format

    Where I am going wrong??

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • September 28, 2010 at 7:21 am

    #1228323

    If you used an OLE DB connection manager, use an OLE DB Destination for the Excel sheet. Not the Excel Destination.

    The table or view name will be your sheet name.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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