I've inherited an environment that extracts data from a Dynamics AX 2012 ERP to a data warehouse for reporting. The original extraction set up by consultants did not include the proper date column needed by accounting. I have performed the following:
- Created the column in the staging tables and destination tables
- opened the packages in Visual Studio and found that each package file uses the same variable User::vSQLBase and contains the query that pulls all columns from the table needed in Dynamics AX. I altered that variable to include the date column.
- I saved my changes and deployed the entire solution back to the data warehouse.
- Ran the job in SQL Server, but none of the columns populated.
I did have an error appear in the debug of Visual Studio when I test executed the package.
Warning: 0x800470C8 at Incremental Load, Read Delta : The external columns for Read Delta are out of synchronization with the data source columns. The column "Document Date" needs to be added to the external columns.
I did contact the consultant who replied with "the new column is not mapped to the staging table in the package, be aware that both the full load and incremental load need the same mapping. and a full load is mandatory since this is a new column". I am further unable to contact the consultant due to budget limitations. What am I missing to get the column to the staging table?