Data transfer from sql table to ax table

hi,

i want to transfer all data from sql tables to ax tables having different database but same database server.

as i have done some steps in it but when i get table data in Resultset…i am unable to copy all data into ax table from result set. please help me to accomplish it… thanx in advance

What’s your version of AX?

AX 2012 r2

I would recommend DIXF reading the data via ODBC.