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 Rowswhat 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?

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 Rowswhat 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.

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 Rowswhat 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.

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 Rowswhat 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).

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 Rowswhat 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).