Flat File row import

  • Hello all

    I have a flat file that that has a parent row (Customer data) in rows 1,3,5,7... etc and the CustomerDetail data in rows 2,4,6,...

    I need to send Customer data to one table and the Details to another table.

    How do i go about doing this in SSIS

    Thanks

  • Cross post.

    Reference post http://www.sqlservercentral.com/Forums/FindPost730354.aspx already closed by OP.



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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