Post reply

Flat File Destination

  • October 6, 2014 at 2:42 am

    #311529

    hi

    i have been asked to add in a Flat File Destination box at different points in my package. is it possible to do so on derived boxes that are all read linked to another derived/look-up box

  • October 6, 2014 at 2:58 am

    #1750241

    Not sure what your question is.

    A derived column has only two outputs: a normal one (the green errow) and the error output (the red arrow).

    So you can hook up a derived column to only one other component, unless you use the error output.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 6, 2014 at 3:12 am

    #1750244

    ya there is a green arrow and a red arrow.

    is there any way i can put a flat file destination as package run through.

    what they want it to be able to show how data was changed before it hit certain points.

    so like a before and after of the data to show what the updates did if you get me

  • October 6, 2014 at 3:26 am

    #1750245

    You could use a Multicast Transform from the derived column. This lets you send the data multiple ways.

    The attached image shows what I mean.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • October 6, 2014 at 3:34 am

    #1750247

    ronan.healy (10/6/2014)

    ya there is a green arrow and a red arrow.

    is there any way i can put a flat file destination as package run through.

    what they want it to be able to show how data was changed before it hit certain points.

    so like a before and after of the data to show what the updates did if you get me

    Which version of SSIS do you use? If 2012 or later, you can use data taps[/url] for this.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 7, 2014 at 1:25 am

    #1750478

    hi

    thanks the Multicast Transform worked perfectly for what i want

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

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