kodaksmile
MIS
Hi all,
I am attempting to load a CSV file into a table in sql and am testing the key's I have in place and wanted to verify the data that could not be loaded would be stored in a file so I have (under the options tab) entered an exception log file name, removed the checkbox for sql 70 and selected source and destination error rows however I only get an errorlog file and no .source or .dest file. I know it can read the file as if I do not enter any duplicate data it loads the data fine. Any suggestions?
Thanks
I am attempting to load a CSV file into a table in sql and am testing the key's I have in place and wanted to verify the data that could not be loaded would be stored in a file so I have (under the options tab) entered an exception log file name, removed the checkbox for sql 70 and selected source and destination error rows however I only get an errorlog file and no .source or .dest file. I know it can read the file as if I do not enter any duplicate data it loads the data fine. Any suggestions?
Thanks