[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName.Trim() | Format-Table -HideTableHeaders

This threw a syntactic error

Yes,the goal is to collect information from 100+ servers in a domain.

I will have a sql script which will exist/run on one source server.

It will take the server names from...

Can we convert an SSIS package to t-sql code ?

Not really I already have a working model using SSIS.

And would like to replicate the same in t-sql.

Any sample codes are appreciated.

I want to do this using only SQL/T-SQL.

I did think of doing the Central management sway.But can we schedule SQL jobs if we use this option?