DotActiv Data Integration FAQs Populating Staging Tables 28
What is the correct format that your data must be in when populating the staging tables?

You must insert your data into the staging tables as per the predefined data types. This is all stipulated and explained in the Staging Tables document provided before the scoping meeting.

Should you be unable to insert your data directly into the staging tables, we can offer you a script which will process a CSV into the staging table. This CSV would require a predefined naming - TableName_Date.CSV, which would go to a predefined location.