Congrats - I just passed 16 yrs last week.

It's actually COLLATION. This is your best...

Jeff Moden (10/12/2011)

---

Oh... be careful, Jason. REVERSE is terribly expensive compared to other...

Maxime.Gagne (10/12/2011)

---

I tried the reverse solution but it did not work out as it is also ordering letters on descending order.

I updated my original post with a more accurate query...

Chad Crawford (10/11/2011)

---

Well, I found Gail's book at the PASS Bookstore, but they won't let me buy it. 🙁

Some wild story about the bookstore not opening for another 15...

Try this

SELECT MerchantID

from #tempSort

ORDER BY LEFT(merchantID,8) DESC,CASE WHEN ISNUMERIC(REVERSE(right(REVERSE(right(merchantid,LEN(MerchantID)-8)),3))) = 1 THEN 1 ELSE 0 end

Sorry couldn't be of more assistance - I hope you get it straightened out.

I haven't used CozyRoc before. Have you checked this page for info?

http://www.cozyroc.com/ssis/sftp-task

Sweet

You're welcome

Add Desc after merchantid in your order by clause

I come up with ~5h55m on that one.

The only way I have been able to achieve this is to use xp_cmdshell and tsql. I am sure there is a method using powershell or a script component...

What queries have you tried so far?

Please post the config screenshots for your sftp connection item.