Hi All, I have two queries and i need to perform union operation on them. How would i implement in SSIS. I know that we can use Execute SQL task to get this....but is there any other way ???? Select OrgId, OrgUnit,MasterCodeDesc from zyz where MasterCode = 2 Union Select OrgId,OrgUnit,MasterCodeDesc from Zyz where MasterCode = 3 Mark as answer if the post help you... Regards, Indraneel A

Hi, you should use the Union All Transformation: http://msdn.microsoft.com/en-us/library/ms140172.aspx David.

Nope this will include the duplicates if any....i dont want duplicates in my result set..Mark as answer if the post help you... Regards, Indraneel A

In that case you need to perform a Group By after the Union All Transformation. Check this link (see the Aggregate after the Union All): http://www.mssqlconsulting.com/SSIS.htm David.