Yeah, that last script was exactly what I was looking for! Thanks, Jason! I appreciate it!

Thanks for the response! I know where you're going with that, in regards to why would you call a Refcursor from SSIS rather than just do a normal data...

I was having the same issue and found a rather strange solution. I found that if I connected to Integration Services via Management Studio, clicked on "run package" and...

I'm having the same issue. Does anyone have any information on this, by chance?

Thanks!  That does work indeed.  I still don't understand why you just simply can't alias in the group by but I guess I'll just accept it and move on 

Never mind!  Finally got it...