Hi Denis,
I very much doubt it is the DROP TABLE which is causing the problem, rather that you have reached the end of the script.
It is quite safe to comment out that line and not drop the table. It will just be a data island in the data model with a list of files. The table isn't required though, and it is best practice to remove it.
If I had to guess what has gone wrong, it would be that one or more tables in the DropBox folder are not in an identical format. This will mean that when they load rather than concatenating they will load into separate tables in the data model, potentially with many common fields causing a large synthetic key. These will show in yellow text in the load progress dialog.
You can;
- Check the DropBox folder to ensure all files are in an identical format
- Check the filename in the loop to ensure the next file to load is one that matches the format
- List all the fields in the LOAD statement so that any rogue fields are ignored and files with missing fields fail to load (so you can identify and fix/remove them)
- Use the CONCATENATE keyword in front of the LOAD. If you go for this you will need to either do differently on the first iteration of the loop, or create a stub table before the loop so that you are always concatenating.
Or you can do all of these things, just to be sure!
Personally I would list all the fields rather than using a * as a matter of course. This could be enough to either fix or highlight your issue.
If not, please post back any error messages.
.png "Luminary Alumni"){kind=icon}
