Without anymore info, the fact that your result is unexpected, I would guess you are performing mathematical functions on text. Things to think about:

Are you removing the space leading the...

It wouldn't be very difficult to set up a web server and a few pages that would allow you to type your sql code into a textbox and use asp.net...

Why don't you just put your working SQL in the connection submenu of a Lookup transformation?

Is there any information that I should have supplied that I didn't? Or is my problem too niche?

I'm currently trying to understand the particulars of the connection string in the...

What are you trying to do? It's possible that neither one of these are the correct tool. No offense, but you sound like a beginner with no budget. If so...