Post reply

Exporting rows to an excel spreadsheet beginning in a specific column and row

  • September 3, 2015 at 8:45 am

    #398990

    I have been tasked with creating an ssis package to export data to an excel spreadsheet. The thing I need to do is have multiple data flows exporting to the same excel tab but have one records set start on say Row 50 Columns A through G then another records set on row 50 but using columns J through k etc. Can this be done in SSIS?

  • September 3, 2015 at 12:04 pm

    #1824444

    Ended up using CozyRoc's Excel Destination Plus

  • September 3, 2015 at 12:08 pm

    #1824447

    Hi

    Is there any contraindication to do that on t-sql level and use single data flow?

    Regards

    Mike

  • September 3, 2015 at 12:24 pm

    #1824452

    You could use cross tabs to create the recordset with the help of the ranking functions.

    I'm not in the mood of creating the whole scenario, but it can certainly be done.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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