Post reply

SSIS dataflow task

  • September 18, 2011 at 4:34 pm

    #243299

    I have one flat file source and 2 tables

    I want to achieve this:

    In one data flow task

    flat file source should be loaded to Table A and from Table A data should go to table B

    flat file -----> table A-------> table B

    1 row 1 row 1 row

    in one data flow task

    Please lemme know if you have any ideas

    Thanks in advance

  • September 19, 2011 at 2:46 am

    #1383183

    Hi,

    Try the Multicast transformation, use of this you can insert to more than destinations from one source.

    Govind

  • September 19, 2011 at 5:26 am

    #1383241

    The multi cast won't do it sequential as you initially asked, it's going to go file to Table A and file to Table B, but this should still be okay. If you must go through table A (why?--no reason based on information provided) then you will have to do two data pumps. Which isn't a bad thing.

  • September 20, 2011 at 4:52 am

    #1383723

    you need to add two data flow task to perform this operatoin sequentially.

    http://letslearnssis.blogspot.com/

  • September 20, 2011 at 5:05 am

    #1383727

    if you want only a single data flow task you can try this:-

    (insert from file to Table A using Bulk Insert ) - -- ( use data flow task to insert into Table B from Table A).

    Jayanth Kurup[/url]

  • September 20, 2011 at 5:12 am

    #1383731

    why is there a restriction to use one data flow task?

    it makes no sense and means that you will end up having to code SQL statements to do the inserts as suggested.

    using two seperate dataflows that sequentially linked is the corect approach

Viewing 6 posts - 1 through 5 (of 5 total)

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