Axapta Data Import

From Axaptapedia

Jump to: navigation, search

I have large flat text files(tab delimited) exported out of our AS400 databases for importing into Axapta 3.0 SP4 system/MS SQL 2000.

These files can be quite large. Our contractor/consultant said that importing into Axapta with native importing tools will take a great amount of time.

What would be the preferred method of importing these files? I have imported test files using SQL server DTS Packages mapping columns to desired table fields.

The load did not take that long. Can this be done and still maintain REFID and DataAreaID index references? Should they default to something or will Axapta create these on Resync commands??

Thanks

MK

Try to write custom inport via AsciiIO class.

Or generate RecId using SystemSequences table see http://www.eggheadcafe.com/forumarchives/axaptaprogramming/Aug2005/post23243136.asp MaxBelugin

Retrieved from "http://www.axaptapedia.com/Axapta_Data_Import"
Personal tools