Migrating SQL Server tables data from one application to another totally different application tables
For a one-off migration that's a good way. For continuing movement of data from a source to destination system e.g. OLTP system to a data warehouse, a proper ETL tool (SSIS/ BIML) would be better.