tag:blogger.com,1999:blog-2303058199815958946.post5447224630669708630..comments2024-03-14T12:53:26.821+01:00Comments on Microsoft SQL Server Integration Services: Sorting in SQL vs sorting in SSISJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2303058199815958946.post-86518338520506586082016-06-07T18:03:07.381+02:002016-06-07T18:03:07.381+02:00I didn't find that either of these methods wor...I didn't find that either of these methods worked. The only way I couldn't the merge join to work is to use the SSIS sort. I'm using a multi text column join criteriaAnonymoushttps://www.blogger.com/profile/08712458050840757151noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-17952579634868313572015-12-06T21:03:16.886+01:002015-12-06T21:03:16.886+01:00100% correct, but this is just an example to make ...100% correct, but this is just an example to make you aware of the differences... and most servers I see are (luckily) case-insensitive.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-54181128535879103622015-12-05T12:51:44.402+01:002015-12-05T12:51:44.402+01:00Actually - the sort order in SQL Server will be de...Actually - the sort order in SQL Server will be dependent on your collation. If you're using a case sensitive collation, the SQL Server sort will also be case sensitive.Anonymousnoreply@blogger.com