Forums

Hello,

I get the following error when trying to load more than 1 product from source file to staging table using the data migration tool.

"Error occured while doing bulkcopy from temp table to entity table 0 Product records inserted in staging"

It works fine with 1 product but not more. Also it works fine when bringing in customers, vendors, customer addresses etc (bulk records)

The Microsoft.Dynamics.AX.DMF.SSISHelper.dll and Microsoft.Dynamics.AX.DMF.SSISHelper.tlb files are in place in the client and server directories 

C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin and C:\Program Files\Microsoft Dynamics AX\60\Server\<AosInstance>\bin

I have also increased the Maximim Buffer Size from 24 to 48 under database tuning in AX Server Config utility.

Could anybody please share thoughts on this?

Thanks,

Charu