We are using staging table to integrate two applications, the staging table is created in NAV, the SSIS job pull the information from the external system and puts it in NAV staging table. but when I check the data in nav it is not available but once I refresh the table the data comes in.
Anyone know how to refresh the table using code because am trying to run the job in NAV to pull the data from staging table to sales order. since the staging table gets updated only when I refresh the table my job was not able to create the sales order.
Any help much appreciated.