Post reply

Header and Detail SSIS

  • January 4, 2016 at 2:55 pm

    #399521

    In our SQL Server 2012 database we have a Header view and a Detail view that collects data from our Account Payable tables. Each view contains a matching Primary Key, however they store different amounts of data. We are trying to figure out how to combine these two views and export to a fixed length flat file, so that it can be exported out and imported into another Accounting system. Unions will not work as they do not have the same number of columns and we have tried bcp and other SQL options, but still no luck. Is this doable with SSIS's? The data needs to be grouped as such:

    Header Data

    Detail Data

    Detail Data

    Header Data

    Detail Data

    Etc...

    Any help or suggestions will be greatly appreciated.

    Thanks

  • January 4, 2016 at 6:42 pm

    #1849425

    Duplicate post. Please post answers at the post already in progress.

    http://www.sqlservercentral.com/Forums/Topic1749535-3077-1.aspx

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 5, 2016 at 8:55 am

    #1849554

    I apologize for the duplicate post. We assumed the T-SQL and SSIS forums differed in forum user knowledge, so we were just trying to cover all options in figuring out a solution to our issue.

    Thanks

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

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