Brandie Tarvin (5/6/2013)
Koen Verbeeck (5/6/2013)
avinash.818 (5/6/2013)
Hi Brandie,If I add a Merge Transform and Pull the Data into Destination,Data from each file Merges as one column in the output,what I need is a separate column for each file
This is my requirement. I have Several files each with One-Column and Several Rows
what I need is all the data is multiple files should go into one file with multiple columns
one column for one file.....can you suggest?
The problem here is you don't have an ID to join on, so you can't use the MERGE JOIN.
I think you'll need a script component as a transformation, where you read the two inputs and create one output row with two columns.
EDITING my response because I remembered what I meant originally.
Not a MERGE Transform. I misspoke. It should be a UNION ALL transform.
A UNION ALL is the same as the MERGE transform, but without the sorting.
It unions the data on a row basis, not a column basis (it's the same as in TSQL, you need to have the same columns).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP