Flat File Destination

Question

Post reply

Flat File Destination

ronan.healy

SSCrazy

Points: 2232
More actions
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

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

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

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

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

ronan.healy SSCrazy Points: 2232 More actions · Answer 2

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

Neil Burton SSC-Insane Points: 22922 More actions · Answer 3

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

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 4

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

ronan.healy SSCrazy Points: 2232 More actions · Answer 5

hi

thanks the Multicast Transform worked perfectly for what i want