An SSIS package is an XML file, it cannot be converted to T-SQL.

What is the overall goal here?

1 Script to connect to multiple hosts, to download a specific table?

SSIS would be ideal for this unless you want to start looping and creating multiple linked servers everywhere