I would nearly always advise the SSIS route. It's more flexible and it enables you to do transformations that you can't (easily) do with T-SQL. It's also easy to handle errors and send notifications.

Using a linked server is less secure since it increases the surface area of your server, giving another possible avenue of attack.

John