Dynamic excel file creation

  • Hello All,

    I created a package that will create folder inside folder ,,... and is working fine for DFT with sql source and flatfile dest, but when I am trying with excel its giving me

    TITLE: Package Validation Error

    ------------------------------

    Package Validation Error

    ------------------------------

    ADDITIONAL INFORMATION:

    Error at Data Flow Task [Excel Destination [497]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.

    Error at Data Flow Task [Excel Destination [497]]: Opening a rowset for "Excel_Destination$" failed. Check that the object exists in the database.

    Error at Data Flow Task [SSIS.Pipeline]: "component "Excel Destination" (497)" failed validation and returned validation status "VS_ISBROKEN".

    Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

    Error at Data Flow Task: There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    Can anyone help me ??

    Thanks

  • Does the Excel file already exist? I think it needs to. Stick with CSV if you can and save yourself a few headaches 🙂

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Thanks Parkin for your reply.

    I need my output must be in Excel, I found one of the articles where he is using a execute sql task to write in an excel sheet and he wants to give this as output to excel destination file, But i couldn't see the excel table creation in my destination excel file.

    http://geekepisodes.com/sqlbi/2011/creating-excel-files-xls-dynamically-from-ssis/

    CREATE TABLE `Pivot_Values` ( `ID` NVARCHAR(10)

    , `column1` int

    , `column2` nvarchar(10)

    , `column3` money

    , `column4` money

    , `column5` money

    )

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

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