Why does COPY FROM LOCAL skip last file when using wildcards?
I am trying to bulk load a bunch of flies into a table using wildcards and the ADONET driver version 10:
COPY <table> from LOCAL '<path>\\SampleData*'
There are 10 files, named SampleData0.txt, SampleData1.txt, ..., SampleData9.txt, but only 9 are loaded into the table, the last one, SampleData9.txt, is skipped.
Any idea? Thanks, Jörg