You should use bcp utility. It is included as apart of every SQL Server installation. It is a command line utility, you specify what data is to be exported via command line parameters to a given file, then you can use bcp to bulk insert the same file to a table on the destination server.

There are lots of command line option and you can look up the details in BOL but in the simplest case, going from SQL server to SQL Server you can use:

output:

bcp "select query" queryout destFilePath -k -N -Sserver -T

input at destination:

bcp dbname.dbo.tablename in destFilePath -E -k -N -Sserver -T