Post reply

DTS Output to Excel

  • June 27, 2002 at 8:26 am

    #105012

    Hi,

    I'm trying to output a view into excel automatically using DTS. Every time it runs i put the filename into a global variable eg "Export 12-06-02.xls", and then use dynamic properties to change the Excel Connection's filename.

    However, when the package trys to run the data pump task it errors saying that the worksheet doesn't exist (of course it doesn't exist as the file has just been created).

    Is there any way round this? I could use the Excel object model, but I'm hesitant to install Excel on the server.

    Any ideas?

    Graham

  • June 27, 2002 at 9:12 am

    #431743

    Right click on a DB table - All tasks - Export data, then follow the wizard to export the data to excel. Save this as a DTS package and view the 'create table' task within the package to see how an excel worksheet is created, then incooperate a similar task into your package.

    Regards,

    Andy Jones

    andyj93@hotmail.com

    .

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

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