that article really speaks to my problem!

Where do I go to set the TypeGuessRows registry setting to a higher number? Where is the registry?

I implemented the first...

opc.three I'll take a look.

thanks for hanging in with me.

First, correction: the destination column is set to nvarchar so it too is Unicode.

Next, I went to excel source advanced editor and...

for what it's worth, advanced editor for the excel source has the datatype property for this column set to Unicode string [DT_WSTR], 255. The destination is varchar(max).

However, as...

No, it isn't destination related. The excel source just shuts the ssis operation down ie. won't bring over anything if I activate that particular column in the mapping of...

Matt, thank you for your answers. I didn't know '=' sign is being deprecated. Will look into alternatives. As far as order is concerned, I'm not in...

Luis thanks, I decided to go with that solution this morning. Appreciate it.

Please accept that the question evolved a little. If you would prefer, I will open a new thread.

I've added a third cte per script; In real life situation...

Lynn, ***please***, I have not oversimplified the problem. The problem is to use CTEs. You are providing an alternate to CTEs, which I am not asking for unless someone can...

please don't take the sample scripts to literally. They are over simplified, so my question is still... how to combine the results of two scripts sharing identical columns, each...

I've added a third cte per script; In real life situation I have to use three per script for the results I'm after. How would I UNION ALL these...

you are right. I'm running to catch bus and my attempt to make new ddl snafood. Shoulda quelched the temptation to be vague and hopeful! Will post.

High Five!"-)

Oh yeah! Nice. Thanks Chris.

In the real world case I have several CTEs in each statement. ie. ct1, followed by ct2, followed by final select. Which CTE do...

Chris,

thanks for reply. I should have posted what the result set was that I'm after. There should be two rows for each person, one recording total count of tickets...

Thank you Malleswarareddy, for the answer.

To answer your question, Calibear, below is DDL demonstrating my reason for needing to UNION ALL two CTEs.

New DDL

create table #temp (TicketID int, Name varchar(20),...