Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
Hi,
I am trying to import data to AX table through SSIS but while importing gettting RecId error.
How can i resolve this? or create RecId dynamically in SSIS ?
Kindly help on this.
Regards,
Rahul
Hi Rahul,
Hope you are doing great, i don't know which method you are using to import data. I would suggest you to use Microsoft Data Migration Framework to import bulk data. I have prepared a blog to share use of of DMF. Below is the link.
dax2012dmfdataimport.blogspot.com/.../microsoft-dynamics-ax-2012-import.html
Mansoor Adeel
AX 2012 Techno Consultant
Thanks for reply..
Actually m trying to import data from flat file to staging table then to actual transaction table
In AX2012 the RECID is a PK or FK used with Linking. It is very bad to use SSIS for this and I have seen a lot of issues on folks that have tried it. With AX2012R2 most of the data import is built in.
Jim is right, there are lots of issues in DMF but it does enough work for data import, we can say its better than using Excell Add-in for bulk data import.