Michael,

Actually, you can manually turn on the IsSorted property with the "Table or View" option. In fact, it's required in order to use a MERGE JOIN component right after...

Hmm. Interestingly enough, the solution seems to be to change the Source from "Table or View" to "SQL Command" and to use an actual SELECT statement with defined column...

I actually had my data flow designed in a top down, but I couldn't get it to all fit on one screen shot, so I moved everything left to right...

Well, my test Data Flow just completed. Even with 7 Sorts, 5 Merge Joins, 4 Conditional Splits and 2 Unions, it finished in 2 hours 32+ minutes, approximately 1/3...

Unfortunately, doing a separate staging DB is out of the question. We don't have the space for it. @=(

Interesting site. Have you used these components before? ...

My situation here is that I'm joining on no less than 6 tables to get my result set, with the final two tables being left outer joins that check for...

Michael,

It just occurred to me... Doesn't using a Merge Join mean you're pulling all columns of the table into SSIS prior to the task anyway?

I think that's why I originally...

WHOOHOO!

That's the ticket, Matt! (Head cold or not, you is GENIUS). And I didn't even have to use the namespace declaration to make it work. The syntax...

I'm still not getting this to work. Does anyone have any thoughts on how to select from an XML column in a table and shred it to a relational...

Subquery then.

Select *

from OrigDs

where ID in (Select Distinct ID from NewDs

where MyNewCol...

Do you have the ability to do a T-SQL join back to your original record source?

If so, then do "Select * from OrigDs od join NewDs nd on od.ID =...

David,

I'm confused. When you say you added an extra column, where did you add it? To the Source before you pulled the data or are you pulling the...

David,

If you've added that extra column, there's no need to use the IN() clause. You can just do the variables as I stated previously and use a "WHERE MyNewCol...

MERGE JOIN is something I'll look into. The one time I played with it, I couldn't quite figure it out. I can't remember exactly what my problem was...

Michael,

Actually, the SSIS package I'm building is pretty huge already and the last few times I tried to use LOOKUP, my performance ended up being worse than using a stored...