Post reply

SSIS 2005 and export to Excel

  • March 20, 2009 at 8:51 am

    #155450

    I am trying to export a table to excel file. I have Excel connection manager and it has default file name assgined. I have Execute SQL task to create a worksheet in the file. When I execute these steps one by one, it creates a file and exports data. When I delete the file and run package it fails giving me error code 0x80040E37. I assume that it does not see the excel file and gives this error. However, my understanding was, the file will be created on the fly. Any help is appreciated.

    thanks,

  • March 20, 2009 at 10:29 am

    #963663

    Using the SSIS default component, you cannot create the excel file on the fly, the file needs to be there and you need to specify the spreadsheet. If you desire to drop the excel file and create it every time it runs the pacakage, you have to use file system task or use some vbscript

    Thanks

    Simon

  • March 22, 2009 at 6:40 pm

    #964211

    Thanks Simon for the reply. It is surprising to know this. I have used similar method in DTS several times. I will try using file system task or script.

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

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