locked
Can destination become source? RRS feed

  • Question

  • Hi to all.

    I've got a question: can destination container in Data Flow become source container? The problem is that I need to get XML file, create a Flat File from that and then load to MS SQL table strings exactly from this Flat File.

    Thank you for your answers.

    Thursday, April 3, 2014 4:30 PM

Answers

  • I'm very sorry, but I have already solved my problem...I just created one more Data Flow task, connected with the first task on Completion condition, and added on this task Flat File source with the same connector, that I used for Flat File destination on the first one.

    It works, but is it "wise" way or there is some another, more suitable?

    Hi Michael,

    Just use the standard Multi Cast transformation to split the input data, one branch going into the flat file and the other one directed to your SQL table.


    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    • Proposed as answer by Mike Yin Thursday, April 10, 2014 8:12 AM
    • Marked as answer by Mike Yin Monday, April 14, 2014 3:44 PM
    Thursday, April 3, 2014 5:11 PM

All replies

  • I'm very sorry, but I have already solved my problem...I just created one more Data Flow task, connected with the first task on Completion condition, and added on this task Flat File source with the same connector, that I used for Flat File destination on the first one.

    It works, but is it "wise" way or there is some another, more suitable?

    Thursday, April 3, 2014 4:48 PM
  • Hi to all.

    I've got a question: can destination container in Data Flow become source container? The problem is that I need to get XML file, create a Flat File from that and then load to MS SQL table strings exactly from this Flat File.

    Thank you for your answers.

    Yes it is possible but what is the use of creating a flat file. We can directly import XML file into SQL Table.

    Refer this link http://www.mssqltips.com/sqlservertip/3141/importing-xml-documents-using-sql-server-integration-services/


    Regards, RSingh

    Thursday, April 3, 2014 4:48 PM
  • Yes it is possible but what is the use of creating a flat file. We can directly import XML file into SQL Table.

    Refer this link http://www.mssqltips.com/sqlservertip/3141/importing-xml-documents-using-sql-server-integration-services/


    Regards, RSingh

    Flat file will be used by another service.
    Thursday, April 3, 2014 4:52 PM
  • I'm very sorry, but I have already solved my problem...I just created one more Data Flow task, connected with the first task on Completion condition, and added on this task Flat File source with the same connector, that I used for Flat File destination on the first one.

    It works, but is it "wise" way or there is some another, more suitable?

    Hi Michael,

    Just use the standard Multi Cast transformation to split the input data, one branch going into the flat file and the other one directed to your SQL table.


    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    • Proposed as answer by Mike Yin Thursday, April 10, 2014 8:12 AM
    • Marked as answer by Mike Yin Monday, April 14, 2014 3:44 PM
    Thursday, April 3, 2014 5:11 PM