LOAD SCRIPT related issue while loading multiple tables.

[wiz_nerd]

I am trying to load tables from ms access database however only one table is loading even when I have selected 5 tables from MS Access database.. Please check the image in the attachment.

[zzyjordan]

Hi, there

I think you need add the "NoConcatenate" to each of your load script and assign a table name to each of them as well.

Below is the sample:

Hope this helps

ZZ

[wiz_nerd · Accepted solution]

Thanks issue resolved.