Hi, I am trying to union two inputs of different structure that is, one input has 5 columns and another input has 1 input which has same data type as the first column in the first input. when i tried to union these two i am getting only rows of the second input, but not first input. i tried similar way earlier, that time it worked. but it is giving problem now. why union all task is behaving in this strange manner..? can any body tell me..please

So let me gut this straight: You have two inputs to your UNION ALL transform, Input One has 5 columns, and Input Two has 1 Column, and that column will be UNION'ed with Column 1 of Input One? Try deleting the UNION ALL Task and starting over. Drag the first input to, then the second, then double-click it to make sure the column(s) mapped correctly.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Hi Todd, Thanks for quick reply, what you understood is correct. I have tried what you told, but it is not working.

what are column data types in two inputs? are they match in data type?http://www.rad.pasfu.com

Both are stings, to be more specific the column in the first input is varchar(100) and there is only one row i need form second input, so i hardcoded it as "SELECT <MailId> as MailId". In the place of <MailId> I will type in mail id in single quoted. I am getting only one row from the second input as the output

could you provide any screen shot from your data flow schema?http://www.rad.pasfu.com

So you want one single record added to the Input One? How are you specifying that single record for Input Two? Are you using an OLE DB Source and a SQL Command as "SELECT 'Some Mail ID' AS MailID". What happens when you remove the second input from the UNION ALL? Does the bunch from Input One go through?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

let us say that first input has 100 rows, second input has 1 row. when both are connected to UNION ALL. one row is coming as output, that is the input of second input when second input is removed 100 rows from first input are flowing down

could you provide screen shots from data flow schema? there maybe something wrong therehttp://www.rad.pasfu.com

how can I give you screen shots? i dont know how to give.

upload them in a free picture uploading site and give us the linkhttp://www.rad.pasfu.com

I am sending the screen shots screen shot 1 which shows 52 rows coming from left and 1 row coming from right and only one row is coming down 1. http://i55.tinypic.com/sqias3.jpg following screen shot 2 shows how the union all is configured 2. http://i56.tinypic.com/b51y6u.jpg follwing screen 3 shows how oledb source is configured. (connection manager is added simply to avoid error) 3. http://i56.tinypic.com/2qa1rnd.jpg tell me if any more details are needed.

OK, I didn't see any problem in your package! you have a source with many columns, and another source with only one column ( MailID) and in the union all you see all columns form first source , and MailID from second source. this is correct! what is your problem?! ( I meant this image: http://i56.tinypic.com/b51y6u.jpg )http://www.rad.pasfu.com

Again you are asking same thing....every thing is correct but result is coming as in the first scree i sent (http://i55.tinypic.com/sqias3.jpg ). what could be problem, i tried by deleting all mappings in union all and resetting, but the problem sustained. what is the reason for this behavior of union all.

Again you are asking same thing....every thing is correct but result is coming as in the first scree i sent (http://i55.tinypic.com/sqias3.jpg ). what could be problem, i tried by deleting all mappings in union all and resetting, but the problem sustained. what is the reason for this behavior of union all.

Again you are asking same thing....every thing is correct but result is coming as in the first scree i sent (http://i55.tinypic.com/sqias3.jpg ). what could be problem, i tried by deleting all mappings in union all and resetting, but the problem sustained. what is the reason for this behavior of union all. I can't see this image correctly! just top toolbar of BIDS showed. could you upload correct image?http://www.rad.pasfu.com

i uploaded the correct picture i can see that, the picture shows "52 rows from left and 1 row from right going in to unionall and only one row is coming down"- could you see what i wrote in bold in first screen i sent. if you could see that is the problem.