Post reply

Export to multiple Workbooks with multiple worksheets

  • December 26, 2017 at 1:44 pm

    #325271

    Hi

    I have a query related to exporting to Excel workbooks in SSIS.

    I've read the two articles below posted by Rafael Salas

    Import Header-Line tables into Dynamic Excel destinations II

    SSIS and Dynamic Excel Destinations Follow up

    Both these solutions are really useful but I'd like to be able to combine these 2 packages to create a single package that creates both multiple Excel workbooks and also multiple worksheets within these workbooks.

    I've been searching a lot of online resources but cannot find the steps to take to create such a package.

    Any help would be much appreciated .

    Thanks

    BO

  • December 27, 2017 at 12:06 am

    #1973543

    Have you followed up also on Steve's advice on your other post here it may be of assistance.

    ...

  • December 27, 2017 at 1:44 am

    #1973546

    Hi

    Yeah, I’ve been able to create for each loop containers for a package that creates an Excel output with multiple worksheets and another that creates multiple Excel workbooks. But what I’m struggling with is incorporating both of them to create multiple Excel files with multiple worksheets....

    BO

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

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