How do I merge two datasets into One

[aroravishal22]

Hi, I am having problems in Merging two datasets into One. I can not use Joins as it is not joining on any fields nor Union as both datasets have different items. I used it in SSIS (SQL Server) as Merge Transformation. Any help woudl be greatly appreciated.
Thank

[rockytopmark]

What data is in each dataset?  You say can't use UNION, so I assume these 2 datasets are very dissimilar in column construct.  How are you merging them in SSIS's Merge Transformation... is the end result more of a UNION or a Join there?

If there is no relationship between DataSet1 and DataSet2, then it would seem join query is out, and ultimately, you are looking to stack the datasets, which resembles a UNION in my thinking.

Any more details you can offer?