Post reply

SSIS Script task to write data in single xlsx file , excel sheet seperetaly

  • April 20, 2020 at 10:53 pm

    #3744832

    DO we have any script task , has to dynamically generate xlsx file. i have 3 different tables. each table data has to go in each tab (3 tabs - sheet1, shee2 and sheet3) in one xlsx file.

    test folder - c:\test

    in this folder i have to create xlsx dynamically

  • April 21, 2020 at 1:32 pm

    #3744965

    If third-party tools are an option our solution can handle this quite easily. We have Premium Excel components available in our SSIS Productivity Pack, which can create a new Excel file/sheet without code and allows for reading/writing from/to Excel files. Additionally, the Premium Excel components can specify the exact row to retrieve or write data to and can output or retrieve data with or without format.

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

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