Copy As400 table to SQL server

Does anyone know the best (fast) way to copy a As400 table to a SQL table.

Currently using the following format which makes a the copying of millions of records slow.

 

<cfloop query=x>

            <cfquery name=sql_qry datasource=sqlDS>

                        INSERT INTO Table1(id, name) VALUES(#x.id#, #x.name#)

            </cfquery>

</cfloop>

 

Copying the contents or the complete table at once will do.